DOLLARDE(fractional_dollar, fraction)

The DOLLARDE function converts a dollar price expressed as a fraction, into a dollar price expressed as a decimal number.

For example, if a dollar value is expressed in 1/16ths of a dollar, the value 7/16 is entered as 0.07 in fractional_dollar and the integer 16 is entered in fraction, the formula:

DOLLARDE(0.07, 16)

returns 0.438. If the fraction is greater than 1/10th only one place is needed after the point.

For example, 3/8ths of a dollar is entered using the formula:

DOLLARDE(0.3, 8)

which returns 0.375.

See also:

Other financial functions