DollarFr

Syntax

DollarFr(FractionValue, Fraction)

FractionValue. Decimal number. Value of this parameter must be greater or equal to zero.

Fraction. Integer that should be used as a denominator. Value of this parameter cannot be equal to zero.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

It converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.

This function is used to convert decimal numbers into fractional currency numbers, such as securities prices.

Formula	Result	Description
=DollarFr(1.125, 16)	1,02	It converts the number 1.125 into the number read as the integer 1 and 2/16.
=DollarFr(A0, 32)	1,04	It converts the number specified in the A0 cell into the number read as the integer 1 and 1/8. The A0 cell contains the 1.125 value.