Related Function:

The DOLLARDE function converts a dollar value, expressed as a fraction, as a dollar value, expressed as a decimal.

Syntax

=DOLLARDE(fractional_dollar,fraction)

Note: The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16, e.g. 1.02 represents $1.125 ($1 + 2/16 = $1.125).

Arguments

Argument Description
fractional_dollar A number expressed as an integer part and a fraction part, separated by a decimal symbol
fraction The integer to use in the denominator of the fraction

Examples

  A B C D
1 Formula Result   Notes
2 =DOLLARDE(1.01,16) 1.0625   Read as 1 + 1/16 because the fraction value is 16
3 =DOLLARDE(1.1,16) 1.625   Read as 1 + 10/16 because the fraction value is 16
4 =DOLLARDE(1.03,32) 1.09375   Read as 1 + 3/32 because the fraction value is 32
5 =DOLLARDE(1.3,32) 1.9375   Read as 1 + 30/32 because the fraction value is 32
6 =DOLLARDE(1.12,32) 1.375   Read as 1 + 12/32 because the fraction value is 32

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied value of fraction is < 0
#DIV/0! Occurs if the supplied value of fraction is equal to 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