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