This function converts a fraction dollar price to a decimal dollar price.
Syntax
DOLLARDE(fractionaldollar,fraction)
Arguments
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 |
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
DOLLARDE(1.10,17)
DOLLARDE(R5C2,R2C4)
Version Available
This function is available in product version 2.0 or later.
See Also
DOLLAR | DOLLARFR | Financial Functions