This function converts a decimal number dollar price to a fraction dollar price.
DOLLARFR(decimaldollar,fraction)
This function has these arguments:
| Argument | Description |
|---|---|
| decimaldollar | Decimal number |
| fraction | Denominator of the fraction; if not an integer, the number is truncated |
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.
Accepts numeric data for both arguments. Returns numeric data.
DOLLARFR(B5,D2)
DOLLARFR(R5C2,R2C4)
DOLLARFR(1.125,16) gives the result 1.02