|1.01 (denominator 16)||1 1/16||1.0625|
|1.1 (denominator 16)||1 10/16||1.625|
|1.03 (denominator 32)||1 3/32||1.09375|
|1.3 (denominator 32)||1 30/32||1.9375|
|1.12 (denominator 32)||1 12/32||1.375|
The Excel Dollarfr function converts a dollar value in decimal notation, into a fractional notation.
The syntax of the function is :
Where the arguments are as follows:
|fractional_dollar||-||The dollar value, expressed as a decimal|
|fraction||-||The denominator for the returned fractional value|
The fraction argument should be supplied as an integer, but if it is provided as a decimal value, it will be truncated to an integer by Excel.
The following spreadsheet shows the Excel Dollarfr function, used to five decimal prices into fractional notation.
The spreadsheet on the left shows the formulas and the spreadsheet on the right shows the results.
Further examples of the Excel Dollarfr function can be found on the Microsoft Office website.
If you get an error from the Dollarfr function, this is most likely to be one of the following:
|#NUM!||-||Occurs if the supplied fraction argument is < 0|
|#DIV/0!||-||Occurs if the supplied fraction argument = 0|
Occurs when Analysis ToolPak add-in is not enabled in your Excel.