Difference between revisions of "Manuals/calci/DOLLAR"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DOLLAR'''</font></font></font><font color="#4848...") |
|||
| Line 1: | Line 1: | ||
| − | + | =DOLLAR(num, dec)= | |
| − | + | *where, <math>num</math> is a number | |
| + | *<math>dec</math> is number of digits to right of decimal point | ||
| − | + | DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | == Description == | |
| − | + | DOLLAR(num, dec) | |
| − | |||
| − | |||
| − | + | For Example, | |
| − | + | DOLLAR(4657.894,2) returns ''$4,657.89'' | |
| − | < | + | *<math>num</math> can be a number or reference to a cell containing a number. |
| + | *<math>dec</math> specifies the number of digits to the right of decimal point to be displayed in the output. | ||
| + | *If <math>dec</math> is negative, the output is rounded to left of the decimal point. | ||
| + | *If <math>dec</math> is omitted, Calci assumes it to be 2. | ||
| + | *If any of the argument is invalid, Calci displays an #NaN error message. | ||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | {| id=" | + | <div id="6SpaceContent" class="zcontent" align="left"> |
| + | |||
| + | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class=" " | '''Function''' | |
| − | + | | class=" " | '''Output''' | |
| − | + | ||
| − | | class=" " | | ||
| − | | class=" " | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |DOLLAR(345.4556,3) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |$345.456 |
| − | | class="sshl_f" | | + | |
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="sshl_f" |DOLLAR(33.52,1) |
| − | | class="sshl_f" | $ | + | | class="sshl_f" |$33.5 |
| − | + | ||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |DOLLAR(0.625) | |
| − | | class=" | + | | class="sshl_f" |$0.63 |
| − | + | ||
| − | |||
| − | | class="sshl_f" | | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |DOLLAR(1768.28,-1) | |
| − | | class="sshl_f" | | + | | class="sshl_f" |$1,770.0 |
| − | | class="sshl_f" | | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |DOLLAR(1334,3) | |
| − | + | | class="sshl_f" |$1,334.00 | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| − | | class="sshl_f" | | ||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/BAHTTEXT | BAHTTEXT]] | ||
| + | |||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Dollar Dollar] | ||
Revision as of 15:34, 31 December 2013
DOLLAR(num, dec)
- where, is a number
- is number of digits to right of decimal point
is a number
is number of digits to right of decimal pointDOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol.
Description
DOLLAR(num, dec)
For Example,
DOLLAR(4657.894,2) returns $4,657.89
- can be a number or reference to a cell containing a number.
- specifies the number of digits to the right of decimal point to be displayed in the output.
- If is negative, the output is rounded to left of the decimal point.
- If is omitted, Calci assumes it to be 2.
- If any of the argument is invalid, Calci displays an #NaN error message.