Difference between revisions of "Manuals/calci/DOLLAR"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*where, <math>num</math> is a number | *where, <math>num</math> is a number | ||
| − | *<math>dec</math> is number of digits to right of decimal point | + | *<math>dec</math> is number of digits to right of the decimal point |
DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol. | DOLLAR() converts a number to a text using currency format and applies a Dollar currency symbol. | ||
| Line 15: | Line 15: | ||
*<math>num</math> can be a number or reference to a cell containing a number. | *<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. | + | *<math>dec</math> specifies the number of digits to the right of the 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 negative, the output is rounded to left of the decimal point. | ||
*If <math>dec</math> is omitted, Calci assumes it to be 2. | *If <math>dec</math> is omitted, Calci assumes it to be 2. | ||
| Line 53: | Line 53: | ||
*[[Manuals/calci/BAHTTEXT | BAHTTEXT]] | *[[Manuals/calci/BAHTTEXT | BAHTTEXT]] | ||
| − | |||
==References== | ==References== | ||
*[http://en.wikipedia.org/wiki/Dollar Dollar] | *[http://en.wikipedia.org/wiki/Dollar Dollar] | ||
Revision as of 16:36, 31 December 2013
DOLLAR(num, dec)
- where, is a number
- is number of digits to right of the decimal point
is a number
is number of digits to right of the 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 the 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.