|
<< Click to Display Table of Contents >> DOLLARFR (convert to dollar price fraction) |
Syntax:
DOLLARFR(Value, Divisor)
Description:
Converts a decimal dollar price into a dollar price expressed as a fraction.
(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:
DOLLARFR(27.5, 8) returns 27.4 (since 27.5 equals the fraction 27 4/8)
See also: