DOLLARDE (FractionalDollar,Fraction)
where,
- is a dollar value in fraction
- is the integer to use as a denominator
DOLLARDE() converts a dollar price in fraction into decimal dollar price.
Description
DOLLARDE (FractionalDollar,Fraction)
- Argument is a number that is expressed as an integer part and fraction part, seperated by decimal symbol.
- Argument is an integer to be used as a denominator in conversion to decimal value.
- Calci divides the fractional part of by the specified value.
e.g. DOLLARDE(1.07,16) is calculated as ($1 + 7/16 = $1.4375000000000004)
- should be >=1, else Calci displays #ERROR message.
- If is not an integer, it is truncated.
Examples
Function | Output |
DOLLARDE(1.11,18) | 1.6111111111111116 |
DOLLARDE(10.0,16) | 10 |
DOLLARDE(3.1,20) | 3.5000000000000004 |
Related Videos
See Also
References