The DOLLARDE function is a monetary function in Microsoft Excel and its function is to convert a greenback value, expressed as a fraction, right into a greenback value, expressed as a decimal quantity. The system for the DOLLARDE function is DOLLARDE (fractional_dollar, fraction).
The syntax for the DOLLARDE function is beneath.
- Fractional_dollar: A quantity expressed as an integer half and a fractional half, separated by a decimal image. It’s required.
- Fraction: The image to use the denominator of the fraction. It’s required.
How to use the DOLLARDE function in Microsoft Excel
To use the DOLLARDE function in Excel. Comply with the steps beneath.
- Launch Microsoft Excel
- Create a desk or use an present desk out of your information
- Place the system into the cell you need to see the outcome
- Press the Enter Key
Launch Microsoft Excel.
Create a desk or use an present desk out of your information.
Kind the system into the cell you need to place the outcome =DOLLARDE(B2, C2).
Press enter to see the outcome.
When you have multiple information in the desk, you possibly can click on the outcome and drag the fill deal with down to see extra outcomes.
There are two different strategies to use the DOLLARDE function
Technique one is to click on the fx button on the highest left of the Excel worksheet.
An Insert Function dialog field will seem.
Contained in the dialog field in the part, Choose a Class, choose Monetary from the listing field.
Within the part Choose a Function, select the DOLLARDE function from the listing.
Then click on OK.
A Function Arguments dialog field will open.
Within the Fractional_dollar entry field, enter into the entry field cell A2.
Within the Fraction entry field, enter into the entry field cell B2.
Then click on OK.
Technique two is to click on the Formulation tab, click on the Monetary button in the Function Library group.
Then choose DOLLARDE from the drop-down menu.
A Function Arguments dialog field will seem.
Can an error happen whereas utilizing the DOLLARDE function in Excel?
Sure, an error can happen whereas utilizing the DOLLARDE function in Excel. If the fraction is lower than 0, DOLLARDE returns the #NUM error worth and if the fraction is bigger than or equal to zero and fewer than 1, DOLLARDE returns the #DIV/0! Error worth.
When you have questions in regards to the tutorial, tell us in the feedback.
