Related Function:

The DOLLARFR function converts a dollar value in decimal notation, into a fractional notation.

Syntax

=DOLLARFR(decimal_dollar,fraction)

Arguments

Argument Description
decimal_dollar A decimal number
fraction The integer to use in the denominator of a fraction

Examples

  A B C D
1 Formula Result   Notes
2 =DOLLARFR(1.0625,16) 1.01   Converts to number read as 1 + 1/16
3 =DOLLARFR(1.625,16) 1.10   Converts to a number read as 1 + 10/16
4 =DOLLARFR(1.09375,32) 1.03   Converts to a number read as 1 + 3/32
5 =DOLLARFR(1.9375,32) 1.30   Converts to a number read as 1 + 30/32
6 =DOLLARFR(1.375,32) 1.12   Converts to a number read as 1 + 12/32

Common Function Error(s)

Problem What went wrong
#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

The Excel DOLLARFR 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