Quick Navigation

DOLLARDE Function

Excel 2007+

Summary

The Excel DOLLARDE function converts a dollar amount expressed as an integer plus fraction (like 1.02 meaning 1 + 2/16) into its precise decimal equivalent. Essential for financial calculations involving security prices and fractional denominations.

Syntax

DOLLARDE(fractional_dollar, fraction)

Parameters

Parameter	Type	Required	Description
fractional_dollar	`Number`	Yes	Dollar amount expressed as integer.fraction (like security price notation)
fraction	`Number`	Yes	Integer denominator that defines fraction precision (8, 16, 32, 64, 100)

Using the DOLLARDE Function

DOLLARDE transforms fractional dollar representations - common in bond trading, stock quotes, and financial instruments - into standard decimal format for calculations, reporting, and analysis. Specify the fraction denominator to match your pricing convention.

Common DOLLARDE Examples

Convert 1-2/16 to Decimal

=DOLLARDE(1.02,16)

Converts 1.02 (1 + 2/16) to 1.125 for 1/16th dollar precision

Convert 1-10/32 to Decimal

=DOLLARDE(1.1,32)

Converts 1.10 (1 + 10/32) to 1.3125 for 1/32nd dollar precision

Eighths Pricing Example

=DOLLARDE(1.3,8)

Converts 1.3 (1 + 3/8) to 1.375

Hundredths (Pennies)

=DOLLARDE(1.25,100)

Converts 1.25 (1 + 25/100) to 1.25

Frequently Asked Questions

1.02 represents 1 + 2/16 = 1 + 0.125 = 1.125 dollars

Yes, DOLLARDE(1.25,100) correctly returns 1.25

8 (eighths), 16 (sixteenths), 32 (thirty-seconds), 64 (sixty-fourths), 100 (pennies)

Common Errors and Solutions

#NUM! error

Cause: Fraction parameter is negative

Solution: Use positive integer for fraction (8, 16, 32, etc.)

#DIV/0! error

Cause: Fraction is 0 or between 0 and 1

Solution: Use integer ≥1 for fraction parameter

#VALUE! error

Cause: Fractional_dollar not recognized as number

Solution: Ensure first parameter uses proper decimal format

Notes

Fraction parameter gets truncated to integer if decimal
Common in fixed income trading and security pricing
Opposite of DOLLARFR function (decimal → fraction)
Excel 2007+ including Microsoft 365
Financial category function

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003, Excel XP, Excel 2000, Excel 97

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+