Practice free

DOLLARDE function

DOLLARDE converts a price written in fractional notation, such as 1.02 for one and two sixteenths, into an ordinary decimal number. It is used with older bond price quotes.

Example

Read it as a sentence: convert the fractional price 1.02, meaning 1 and 2/16, into a decimal number, which gives 1.125.

Practice this in the app

Syntax

DOLLARDE(fractional_dollar, fraction)

fractional_dollar (required)
Price written as whole.fraction, e.g. 1.02 for 1 and 2/16.
fraction (required)
Denominator of the fraction (whole number).

Returns: The price as an ordinary decimal number.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=DOLLARDE(1.02,16) 1.125 1.02 / 16
=DOLLARDE(1.1,32) 1.3125 1.1 / 32
=DOLLARDE(-1.02,16) -1.125 Negative
=DOLLARDE(1.02,16.9) 1.125 Fraction 16.9 truncates
=DOLLARDE(1.5,1) 1.5 Fraction 1
=DOLLARDE("1.02","16") 1.125 Text number
=DOLLARDE(1.02,0) #DIV/0! Fraction 0
=DOLLARDE(1.02,-1) #NUM! Fraction negative

Watch out for

  • A fraction below 1 returns #NUM! and 0 returns #DIV/0!.
  • The digits after the point are the numerator, not a decimal.

Where it works

Excel
DOLLARDE is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .