Difference between revisions of "Manuals/calci/DOLLAR"
Jump to navigation
Jump to search
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DOLLAR( | + | <div style="font-size:30px">'''DOLLAR (Amount,Decimals)'''</div><br/> |
| − | *where, <math> | + | *where, <math>Amount</math> is a number |
| − | *<math> | + | *<math>Decimals</math> is number of digits to right of the decimal point |
| − | + | **DOLLAR(), converts a number to text, using the $ (dollar) currency format. | |
| − | DOLLAR() converts a number to | ||
== Description == | == Description == | ||
| − | DOLLAR( | + | DOLLAR (Amount,Decimals) |
For Example, | For Example, | ||
| Line 14: | Line 13: | ||
DOLLAR(4657.894,2) returns ''$4,657.89'' | DOLLAR(4657.894,2) returns ''$4,657.89'' | ||
| − | *<math> | + | *<math>Amount</math> can be a number or reference to a cell containing a number. |
| − | *<math> | + | *<math>Decimals</math> specifies the number of digits to the right of the decimal point to be displayed in the output. |
| − | *If <math> | + | *If <math>Decimals</math> is negative, the output is rounded to left of the decimal point. |
| − | *If <math> | + | *If <math>Decimals</math> is omitted, Calci assumes it to be 2. |
*If any of the argument is invalid, Calci displays an #NaN error message. | *If any of the argument is invalid, Calci displays an #NaN error message. | ||
| Line 61: | Line 60: | ||
*[http://en.wikipedia.org/wiki/Dollar Dollar] | *[http://en.wikipedia.org/wiki/Dollar Dollar] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:09, 22 August 2018
DOLLAR (Amount,Decimals)
- where, is a number
- is number of digits to right of the decimal point
- DOLLAR(), converts a number to text, using the $ (dollar) currency format.
is a number
is number of digits to right of the decimal point
Description
DOLLAR (Amount,Decimals)
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.
Examples
| Function | Output |
| DOLLAR(345.4556,3) | $345.456 |
| DOLLAR(33.52,1) | $33.5 |
| DOLLAR(0.625) | $0.63 |
| DOLLAR(1768.28,-1) | $1,770.0 |
| DOLLAR(1334,3) | $1,334.00 |
Related Videos
See Also
References