Description
The Excel Dollarde function converts a dollar value, expressed as a fraction, as a dollar value, expressed as a decimal.
The syntax of the function is :
DOLLARDE( fractional_dollar, fraction )
Where the arguments are as follows:
The fraction argument should be supplied as an integer, but if this is provided as a decimal value, Excel will truncate it to an integer.
Excel Dollarde Function Examples
The following spreadsheet shows the Excel Dollarde function, used to covert prices in fractional notation to decimal notation.
The formulas used are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Dollarde Function Errors
The most common errors from the Dollarde function are listed in the following table:
Common Errors
No comments:
Post a Comment