Difference between revisions of "Manuals/calci/DOLLARDE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DOLLARDE'''</font><font size="2">(</font><fo...") |
|||
| Line 1: | Line 1: | ||
| − | + | =DOLLARDE(FD, Fraction)= | |
| − | + | where, | |
| + | *<math>FD</math> is a dollar value in fraction | ||
| + | *<math>Fraction</math> is the integer to use as a denominator | ||
| − | + | DOLLARDE() converts a dollar price in fraction into decimal dollar price. | |
| − | + | == Description == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | DOLLARDE(FD, Fraction) | |
| − | </ | + | *Argument <math>FD</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. | |
| − | < | + | *Calci divides the fractional part of <math>FD</math> by the specified <math>Fraction</math> value. |
| − | + | e.g. DOLLARDE(1.07,16) is calculated as ($1 + 7/16 = $1.4375000000000004) | |
| − | < | + | *<math>Fraction</math> should be >=1, else Calci displays #ERROR message. |
| − | + | *If <math>Fraction</math> is not an integer, it is truncated. | |
| − | |||
| − | + | == Examples == | |
| − | + | <div id="6SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | <div id=" | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Function''' |
| − | + | | class=" " | '''Output''' | |
| − | | class=" " | | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |DOLLARDE(1.11,18) | |
| − | | class="sshl_f" | 1.11 | + | | class="sshl_f" |1.6111111111111116 |
| − | + | ||
| − | | class=" | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |DOLLARDE(10.0,16) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |10 |
| − | | class=" | + | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" |DOLLARDE(3.1,20) |
| − | + | | class="sshl_f" |3.5000000000000004 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" | ||
| − | |||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/DOLLARFR | DOLLARFR]] | ||
| + | *[[Manuals/calci/DOLLAR | DOLLAR]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Dollar Dollar] | ||
Revision as of 16:07, 16 January 2014
DOLLARDE(FD, Fraction)
where,
- is a dollar value in fraction
- is the integer to use as a denominator
is a dollar value in fraction
is the integer to use as a denominatorDOLLARDE() converts a dollar price in fraction into decimal dollar price.
Description
DOLLARDE(FD, 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.