Manuals/calci/DOLLAR
Jump to navigation
Jump to search
DOLLAR(num, dec)
- where, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle num} is a number
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle dec} 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.
Description
DOLLAR(num, dec)
For Example,
DOLLAR(4657.894,2) returns $4,657.89
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle num} can be a number or reference to a cell containing a number.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle dec} specifies the number of digits to the right of the decimal point to be displayed in the output.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle dec} is negative, the output is rounded to left of the decimal point.
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle dec} 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 |