Description
DOLLAR is a text function in Excel. Having two arguments where first argument number is mandatory while second argument decimals is optional. It’s default value is 2 and if you use negative sign, the number is rounded to the left of the decimal sign. DOLLAR converts the number in $#,##0.00_);($#,##0.00) format, currency symbol may change based on your local settings
Syntax
DOLLAR(number, [decimals])
Example

- DOLLAR Excel function converted the number to text in currency format.
- DOLLAR Excel function converted the number to text in currency format and rounded off as second argument is 0.
- DOLLAR Excel function converted the number to text in currency format and rounded off to one digit left to the decimal as second argument is -1.
- DOLLAR Excel function converted the number to text in currency format and rounded off to two digit left to the decimal as second argument is -1.
- SUM of the numbers is 0 as DOLLAR has converted the number to text.
0 Comments