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.
Version 
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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas