The DOLLARFR function returns a decimal number as a fractional price.
This can be useful when you want to present monetary amounts in a more convenient form by separating the whole and fractional parts.
Syntax
DOLLARFR(decimal_price, unit)
Argument |
Description |
Permitted values |
|---|---|---|
decimal_price |
Decimal number to be converted |
Integer or a decimal fraction |
unit |
Base of the number system for the fractional part |
Positive integer: most often 8, 16, 32, or 64 |
Examples of use
Conversion of 5.625 dollars to fractional form:
=DOLLARFR(5.625, 8)
This formula will return 5.5, which corresponds to 5 dollars and 5/8 dollars.
Conversion of 3.25 dollars:
=DOLLARFR(3.25, 100)
The result will be 3.25, which corresponds to 3 dollars and 25 cents.
Conversion of 2.6875 dollars with a fractional part of 16:
=DOLLARFR(2.6875, 16)
This formula will return 2 dollars and 11/16 dollars.
Notes
Make sure that the fraction you use corresponds to the format accepted in your country or in your professional field.