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: