|
<< Click to Display Table of Contents >> DOLLARDE (convert to dollar price decimal) |
Syntax:
DOLLARDE(Value, Divisor)
Description:
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 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: