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 add-in is not enabled in your Excel.
You will need to enable the add-in if you want to use the Excel Dollarfr function.

  +   Show How to Do This in Excel 2003:

  +   Show How to Do This in Excel 2007:

  +   Show How to Do This in Excel 2010:

Return to the Excel Financial Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net