The DOLLARDE operate is a monetary operate in Microsoft Excel and its goal is to transform a greenback worth, expressed as a fraction, right into a greenback worth, expressed as a decimal quantity. The method for the DOLLARDE operate is
DOLLARDE (fractional_dollar, fraction).
The syntax for the DOLLARDE operate 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 make use of the denominator of the fraction. It’s required.
Methods to use the DOLLARDE operate in Microsoft Excel
To make use of the DOLLARDE operate in Excel. Comply with the steps beneath.
- Launch Microsoft Excel
- Create a desk or use an current desk out of your recordsdata
- Place the method into the cell you need to see the outcome
- Press the Enter Key
Launch Microsoft Excel.
Create a desk or use an current desk out of your recordsdata.
Kind the method into the cell you need to place the outcome =DOLLARDE(B2, C2).
Press enter to see the outcome.
When you’ve got a couple of knowledge within the desk, you possibly can click on the outcome and drag the fill deal with all the way down to see extra outcomes.
There are two different strategies to make use of the DOLLARDE operate
Technique one is to click on the fx button on the highest left of the Excel worksheet.
An Insert Perform dialog field will seem.
Contained in the dialog field within the part, Choose a Class, choose Monetary from the record field.
Within the part Choose a Perform, select the DOLLARDE operate from the record.
Then click on OK.
A Perform 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 within the Perform Library group.
Then choose DOLLARDE from the drop-down menu.
A Perform Arguments dialog field will seem.
Can an error happen whereas utilizing the DOLLARDE operate in Excel?
Sure, an error can happen whereas utilizing the DOLLARDE operate in Excel. If the fraction is lower than 0, DOLLARDE returns the #NUM error worth and if the fraction is larger than or equal to zero and fewer than 1, DOLLARDE returns the #DIV/0! Error worth.
When you’ve got questions in regards to the tutorial, tell us within the feedback.