DOLLAR Function in Excel rounds the supplied number to a specified number of decimal places and converts them into currency format by adding dollar symbol in front.
Syntax of DOLLAR Function in Excel:
DOLLAR(number, [decimals])
Where,
- number – The number to be converted into currency format
- [decimal] – An optional argument that specifies the number of decimal places to be rounded off. If omitted, it takes default value as 2 and rounds off to 2 decimal places
Example of DOLLAR Function in Excel:
Formula:
- In first example Dollar function is passed only with numeric value so that it will be rounded off to default 2 decimal places.
- From second example onwards numeric value is passed along with [decimal] argument which says the number of decimal places to be round off.
- Dollar Function converts the number into currency format by adding dollar symbol in front
So the result will be
Result:
Note: #VALUE! Error occurs if either of the supplied arguments are non-numeric.