Google Sheets
DOLLARDE function in Google Sheets
Converts a price quotation given as a decimal fraction into a decimal value.
=DOLLARDE(fractional_price, unit)DOLLARDE syntax and parameters
Two arguments, two required.
- fractional_pricenumberRequired
The price quotation given using fractional decimal conventions.
- unitnumberRequired
The units of the fraction, e.g. 8 for 1/8ths or 32 for 1/32nds.
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 Excel
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 Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel