Google Sheets
DOLLARFR function in Google Sheets
Converts a price quotation given as a decimal value into a decimal fraction.
=DOLLARFR(decimal_price, unit)DOLLARFR syntax and parameters
Two arguments, two required.
- decimal_pricenumberRequired
The price quotation given as a decimal value..
- unitnumberRequired
The units of the desired fraction, e.g. 8 for 1/8ths or 32 for 1/32nds.
DOLLARFR examples
Formulas you'll actually reuse.
A decimal price back into 16ths notation:
=DOLLARFR(1.125, 16)Result
1.0299.5 as a bond quote in 32nds:
=DOLLARFR(99.5, 32)Result
99.16
DOLLARFR in Excel
Same name — your formula ports as-is.
Try DOLLARFR in the playground
Edit the example — nothing to install.
Preloaded with the DOLLARFR formula from Example 1 — change anything and watch it respond.
Loading the editor…
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