Check Sheet Logo
Check Sheet

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:

=DOLLAR(number, [number_of_places])
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.

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 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.

Learn More

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