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