Excel
DOLLARDE function in Excel
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
=DOLLARDE(fractional_dollar, fraction)DOLLARDE syntax and parameters
Two arguments, two required.
- fractional_dollarnumberRequired
A number expressed as an integer part and a fraction part, separated by a decimal symbol.
- fractionnumberRequired
The integer to use in the denominator of the fraction.
DOLLARDE examples
Formulas you'll actually reuse.
A price quoted as 1 and 2/16 into a decimal:
=DOLLARDE(1.02, 16)Result
1.125A bond quote in 32nds (99.16 = 99 and 16/32) as a decimal:
=DOLLARDE(B2, 32)Result
99.5
DOLLARDE in Google Sheets
Same name — your formula ports as-is.
Try DOLLARDE in the playground
Edit the example — nothing to install.
Preloaded with the DOLLARDE formula from Example 1 — change anything and watch it respond.
Loading the editor…
DOLLARDE errors
What they mean — and the fixes.
#DIV/0!fraction is 0 — it must be a positive whole number such as 8, 16 or 32.
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets