Exceljet

Quick, clean, and to the point

Excel DOLLARDE Function

Excel DOLLARDE function
Summary 

The Excel DOLLARDE function converts a dollar price entered with a special notation to a dollar price displayed as a decimal number.  The DOLLARFR function does the opposite conversion.

Purpose 
Convert dollar price as fraction to decimal
Return value 
Equivalent decimal number
Syntax 
=DOLLARDE (fractional_dollar, fraction)
Arguments 
  • fractional_dollar - Dollar component in special fractional notation.
  • fraction - The denominator in the fractional unit. 8 = 1/8, 16 = 1/16, 32 = 1/32, etc.
Usage notes 

The DOLLARDE function is a financial function which converts values pricing entered with a particular fractional notation into an equivalent decimal number. It can be used for securities where pricing is given to the nearest 1/8, 1/16, 1/32, etc.

For example, to convert the the price "3 and 1/16" to an equivalent decimal value, you can use the DOLLARDE function like this:

=DOLLARDE(3.01,16) // returns 3.0625

Notice first argument shows the whole dollar value on the left, and the decimal component is used to express the numerator (.01 = 1, .11 = 11, etc.). The second argument is the denominator.

In the example shown, the formula column E, copied down, is:

=DOLLARDE(C6,D6)

On each row, the DOLLARDE function picks up the fractional dollar notation from column C and the denominator from column D.

Notes

  1. Both fractional_dollar and fraction arguments must be numeric values.
  2. The value for fraction must be greater than zero.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.