Home »
ExcelBuiltInFunctions »
ExcelFinancialFunctions »
ExcelDollarfrFunction
The Excel DOLLARFR Function
Related Function:
DOLLARDE
Fractional Dollar Values
The Excel Dollarde and
Dollarde functions are
designed for working with security prices, which are often quoted as fractional values. Some examples are given below:
fractional notation

fraction

decimal

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 
Basic Description
The Excel Dollarfr function converts a dollar value in decimal notation, into a fractional notation.
The syntax of the function is :
DOLLARFR( decimal_dollar, fraction )
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.
Excel Dollarfr Function Examples
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.
Formulas:

A 
B 
1 
=DOLLARFR( 1.0625, 16 ) 
 equal to 1 + 1/16 
2 
=DOLLARFR( 1.625, 16 ) 
 equal to 1 + 10/16 
3 
=DOLLARFR( 1.09375, 32 ) 
 equal to 1 + 3/32 
4 
=DOLLARFR( 1.9375, 32 ) 
 equal to 1 + 30/32 
5 
=DOLLARFR( 1.375, 32 ) 
 equal to 1 + 12/32 

Results:

A 
B 
1 
$1.01 
 equal to 1 + 1/16 
2 
$1.1 
 equal to 1 + 10/16 
3 
$1.03 
 equal to 1 + 3/32 
4 
$1.3 
 equal to 1 + 30/32 
5 
$1.12 
 equal to 1 + 12/32 

Further examples of the Excel Dollarfr function can be found on the
Microsoft Office website.
Dollarfr Function Errors
If you get an error from the Dollarfr function, this is most likely to be one of the following:
Common Errors
#NUM! 
 
Occurs if the supplied fraction argument is < 0

#DIV/0! 
 
Occurs if the supplied fraction argument = 0

#NAME? 
 
Occurs when Analysis ToolPak addin is not enabled in your Excel.
You will need to enable the addin if you want to use the Excel Dollarfr function.
+ Show How to Do This in Excel 2003:
 From the Tools dropdown menu, select the option AddIns ...
 An 'AddIns' window will pop up. From this, select the option Analysis ToolPak and click OK
+ Show How to Do This in Excel 2007:
 Click the Microsoft button on the top left of your spreadsheet and select
the Excel Options button
 From the menu on the left hand side, select AddIns
 In the 'Manage:' box, select Excel Addins and click Go...
 An 'AddIns' window will pop up. From this, select the option Analysis ToolPak and click OK
+ Show How to Do This in Excel 2010 or Excel 2013:
 Click the File tab (top left of your spreadsheet) and select Options
 From the menu on the left hand side, select AddIns
 If the window that pops up doesn't show the 'Addins' list, use the 'Manage:'
dropdown menu (at the bottom of the window) to select Excel Addins. Click Go...
 From the 'AddIns' window, select the option Analysis ToolPak and click OK
