DOLLARfunction 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
- Examples of using
DOLLARformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
DOLLARformula in Google Sheets.
Displaying monetary values
DOLLAR function is commonly used to display monetary values in a more readable and standardized way. For example,
DOLLAR function can be used to round numbers to a specific number of decimal places. For example,
=DOLLAR(1234.567, 1) returns
Changing the currency symbol
DOLLAR function can be used to display monetary values in different currencies by changing the currency symbol. For example,
=DOLLAR(1234.567, 2)&" €" returns
DOLLARnot working? Here are some common mistakes people make when using the
DOLLARGoogle 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
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
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.
The following functions are similar to
DOLLAR or are often used with it in a formula:
ROUNDformula 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 the
placesparameter is not specified, the formula rounds to the nearest integer.
SUMfunction in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells.
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.
IFformula 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.
VLOOKUPfunction 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.
You can learn more about the
DOLLAR Google Sheets function on Google Support.