DOLLAR(num, dec)
- where, is a number
- 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
- 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.