DOLLARFR

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

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.

Make sure that the fraction you use corresponds to the format accepted in your country or in your professional field.