DOLLARDE Function
Converts a dollar price expressed as a fraction into a decimal number.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| fractional_dollar | Number expressed as a fraction, such as 1.02 for 1 and 2/16. | Required |
| fraction | Integer to use in the denominator of the fraction. | Required |
Basic Example
Convert 1.02 (1 and 2/16) to decimal
=DOLLARDE(1.02, 16)1 and 2/16 equals 1.125 in decimal.
Advanced Examples
Example 1: Bond price in 32nds
Fixed incomeConvert 100.16 (100 and 16/32) to decimal
=DOLLARDE(100.16, 32)How DOLLARDE Works
DOLLARDE takes the integer part of the input as the whole dollar amount and the decimal part as the numerator over the specified fraction. For example, 1.02 with fraction 16 becomes 1 + 2/16.
Important Notes & Limitations
Fraction must be an integer.
Integer part of the input is the whole dollar amount.
Decimal part is the numerator.
Common Errors & Fixes
#DIV/0! errorFraction is zero.Fix: Use a non-zero integer for the fraction.
#VALUE! errorFraction is not an integer.Fix: Use an integer value for the fraction.
Download Practice File
DOLLARDE
dollardePractice DOLLARDE with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the DOLLARDE function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps