Difference between revisions of "Manuals/calci/DOLLARDE"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =DOLLARDE( | + | <div style="font-size:30px">'''DOLLARDE (FractionalDollar,Fraction)'''</div><br/> |
where, | where, | ||
| − | *<math> | + | *<math>FractionalDollar</math> is a dollar value in fraction |
*<math>Fraction</math> is the integer to use as a denominator | *<math>Fraction</math> is the integer to use as a denominator | ||
| − | + | **DOLLARDE(), converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. | |
| − | DOLLARDE() converts a dollar price | ||
== Description == | == Description == | ||
| − | DOLLARDE( | + | DOLLARDE (FractionalDollar,Fraction) |
| − | *Argument <math> | + | *Argument <math>FractionalDollar</math> is a number that is expressed as an integer part and fraction part, seperated by decimal symbol. |
*Argument <math>Fraction</math> is an integer to be used as a denominator in conversion to decimal value. | *Argument <math>Fraction</math> is an integer to be used as a denominator in conversion to decimal value. | ||
| − | *Calci divides the fractional part of <math> | + | *Calci divides the fractional part of <math>FractionalDollar</math> by the specified <math>Fraction</math> value. |
e.g. DOLLARDE(1.07,16) is calculated as ($1 + 7/16 = $1.4375000000000004) | e.g. DOLLARDE(1.07,16) is calculated as ($1 + 7/16 = $1.4375000000000004) | ||
Latest revision as of 16:09, 22 August 2018
DOLLARDE (FractionalDollar,Fraction)
where,
- is a dollar value in fraction
- is the integer to use as a denominator
- DOLLARDE(), converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
is a dollar value in fraction
is the integer to use as a denominator
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