# DOLLAR

The `DOLLAR` 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.

## Usage

Use the `DOLLAR` formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

Parameters:
1. 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.
2. 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 the `DOLLAR` 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.

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 the `places` 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.

You can learn more about the `DOLLAR` Google Sheets function on Google Support.