Formulas > =DOLLARFR()

How To Use DOLLARFR() Function in Google Sheets


Converts a price quotation given as a decimal value into a decimal fraction.

Common questions about the DOLLARFR formula include:
What exactly does the DOLLARFR formula do?
What data can this formula be used on?

The DOLLARFR formula can be used to format a number to a specific currency. It is particularly helpful for formatting large numbers into a complex format with currency codes and thousands separators.

The DOLLARFR formula is commonly mistyped as DOLLARF or DOLLAROF.

Common ways the DOLLARFR formula is used inappropriately include using it for transforming money across different currencies or erroneously using it on data types such as strings and dates.

Common pitfalls when using the DOLLARFR formula include forgetting to add the third parameter (which sets the currency code) or not taking into account whether the cell which contains the data has already been formatted.

Common mistakes when using the DOLLARFR Formula include passing an incorrect currency code to the formula and not representing the data in the required currency symbol.

Common misconceptions people might have with the DOLLARFR Formula include thinking it can be used to convert currencies or forgetting to include the third parameter when using the formula.

How To Actually Use DOLLARFR() in Sheets

DOLLARFR(decimal_price, unit)

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

Generate a DOLLARFR() 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.


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.