This function converts a decimal number dollar price to a fraction dollar price.
Syntax
DOLLARFR(decimaldollar,fraction)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| decimaldollar | Decimal number |
| fraction | Denominator of the fraction; if not an integer, the number is truncated |
Remarks
If fraction is not an integer, it is truncated. If fraction is less than 0, a #NUM! error is returned. If fraction is 0, a #DIV/0! error is returned.
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
DOLLARFR(B5,D2)
DOLLARFR(R5C2,R2C4)
DOLLARFR(1.125,16) gives the result 1.02
Version Available
This function is available in product version 2.0 or later.
See Also
DOLLAR | DOLLARDE | Financial Functions