Formulas > =DOLLAR()

# How To Use DOLLAR() Function in Google Sheets

Description

Formats a number into the locale-specific currency format.

Common Questions about the DOLLAR Formula:
What is the DOLLAR Formula? How does the DOLLAR Formula work? How do you use the DOLLAR Formula?

How to use the DOLLAR Formula Appropriately:
The DOLLAR formula is a convenient tool for making sure cell references are absolute in Google Sheets. This formula wraps the cell reference usually made with a column letter and row number inside of the DOLLAR specificiation which means the cell referenced in that formula will stay the same regardless of where the formula is dragged or copied too.

How the DOLLAR Formula can be Commonly Mistyped:
The most common mistake in using the DOLLAR formula is to not surround references with the DOLLAR specification. This usually causes incorrect results because the cell reference will change when the formula is dragged or copied to different cells.

Common Ways the DOLLAR Formula is Used Inappropriately:
Sometimes the DOLLAR formula can be difficult to read. It can also be difficult to determine when to use the DOLLAR formula. People often mistakenly think the DOLLAR formula will make all cell references absolute, when in reality it will only keep row and column references absolute.

Common Pitfalls When Using the DOLLAR Formula:
Not wrapping all references inside of the DOLLAR specification will cause incorrect results. This is the most common mistake with this formula. Additionally, incorrectly typing the DOLLAR formula will also cause errors.

Common Mistakes When Using the DOLLAR Formula:
Misunderstanding when to use the DOLLAR formula and forgetting to wrap all references inside of the specification are the most common mistakes with the DOLLAR formula.

Common Misconceptions People Might Have with the DOLLAR Formula:
People often mistakenly think the DOLLAR formula will make all cell references absolute, when in reality it will only keep row and column references absolute. Additionally, some people think that using the DOLLAR formula will force the referenced cells to stay in the same place, when in reality the formula will keep the references absolute, but dragging will still move the referenced cells."

How To Actually Use DOLLAR() in Sheets

`DOLLAR(number, [number_of_places])`

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Generate a DOLLAR() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.