This function converts a fraction dollar price to a decimal dollar price.
DOLLARDE(fractionaldollar,fraction)
This function has these arguments:
| Argument | Description |
|---|---|
| fractionaldollar | Numeric value expressed as a fraction |
| 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.
DOLLARDE(1.10,17)
DOLLARDE(R5C2,R2C4)