Excel
DOLLARFR function in Excel
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
=DOLLARFR(decimal_dollar, fraction)DOLLARFR syntax and parameters
Two arguments, two required.
- decimal_dollarnumberRequired
A decimal number.
- fractionnumberRequired
The integer to use in the denominator of a fraction.
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 Google Sheets
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 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