DOLLAR
TheDOLLAR
function converts a number to text with a currency format. It is commonly used to display monetary values in a more readable and standardized way. The function takes one required argument and one optional argument.
 How to use
DOLLAR
formula?  Examples of using
DOLLAR
formula DOLLAR
formula not working? Similar formulas to
DOLLAR
Usage
Use the DOLLAR
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 number (required):
The number to be converted to currency format. It can be a reference to a cell containing a number, a number itself, or a formula that evaluates to a number.  number_of_places (optional):
The number of decimal places to display. If omitted, the default value is 2. If the value is negative, the function rounds the number to the left of the decimal separator.
Examples
Here are a few example use cases that explain how to use theDOLLAR
formula in Google Sheets.
Displaying monetary values
The DOLLAR
function is commonly used to display monetary values in a more readable and standardized way. For example, =DOLLAR(1234.567)
returns $1,234.57
.
Rounding numbers
The DOLLAR
function can be used to round numbers to a specific number of decimal places. For example, =DOLLAR(1234.567, 1)
returns $1,234.6
.
Changing the currency symbol
The DOLLAR
function can be used to display monetary values in different currencies by changing the currency symbol. For example, =DOLLAR(1234.567, 2)&" €"
returns 1,234.57 €
.
Common Mistakes
DOLLAR
not working? Here are some common mistakes people make when using the DOLLAR
Google Sheets Formula:
Forgetting to specify the number argument
One common mistake when using the DOLLAR
formula is forgetting to specify the number argument. This will result in a #VALUE! error. Make sure to always specify the number argument.
Specifying a negative number_of_places
The DOLLAR
formula rounds the number to the specified number of decimal places. If you specify a negative number_of_places, the number will be rounded to the left of the decimal point, resulting in an incorrect value. Make sure to always specify a positive number_of_places.
Using the wrong currency symbol
The DOLLAR
formula adds a dollar sign as a prefix by default. If you need to use a different currency symbol, make sure to specify it as a string in the formula. Using the wrong currency symbol can lead to confusion and errors.
Related Formulas
The following functions are similar to DOLLAR
or are often used with it in a formula:

ROUND
The
ROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If theplaces
parameter is not specified, the formula rounds to the nearest integer. 
SUM
The
SUM
function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

IF
The
IF
formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions. 
VLOOKUP
The
VLOOKUP
function is a lookup formula used to search for a value in the first column of a range of cells (the search key) and return a value in the same row from a specified column in that range. This function is most commonly used to look up and retrieve data from a table.
Learn More
You can learn more about the DOLLAR
Google Sheets function on Google Support.