|
<< Click to Display Table of Contents >> DOLLARDE (convert to dollar price decimal) |
Syntax:
DOLLARDE(Value, Divisor)
Description:
This converts a dollar price expressed as a fraction into a decimal dollar price.
(In the USA, it is common practice for some types of financial transactions to represent monetary amounts as fractions – for example, 27 4/8 instead of 27.50.)
Value is the number to be converted.
Divisor is the denominator of the fraction. It must be greater than or equal to 1. Divisor should be an integer. Digits to the right of the decimal point are ignored.
Example:
DOLLARDE(27.4, 8) converts the fraction 27 4/8 into the decimal value 27.5.
See also: