DOLLARFR
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
FinancialFinance & Accounting
What it does
Converts a decimal price to a fractional price (e.g., 1.125 to 1.02 for 1 and 2/16).
Syntax
DOLLARFR(decimal_dollar, fraction)
Arguments
decimal_dollar(number) — Decimal number.fraction(number) — Integer to use for the denominator.
Examples
Convert to Fraction
Convert 1.125 to 16ths.
FORMULA
=DOLLARFR(1.125, 16)
RESULT
1.02
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Decimal | Base |
| 2 | 1.125 | 16 |