DollarDe

Syntax

DollarDe(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.

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

Formula	Result	Description
=DollarDe(1.02, 16)	1,125	It transforms the 1.02 number read as 1 integer and 2/16, into the decimal number.
=DollarDe(A0, B0)	13,25	It converts the fraction specified in the A0 and B0 cells into the decimal number. The A0 cell contains the 12.5 value, the B0 cell contains the 4 value.