How to use DOLLARFR Google Sheets formula?

The syntax for the DOLLARFR formula is =DOLLARFR(decimal_price, unit), it has 2 required parameters.

DOLLARFR

The DOLLARFR function converts a decimal price into a fraction of a dollar, rounded to the nearest fraction. It is commonly used for financial calculations.

How to use DOLLARFR formula?
Examples of using DOLLARFR formula
DOLLARFR formula not working?
Similar formulas to DOLLARFR

Usage

Use the DOLLARFR formula with the syntax shown below, it has 2 required parameters:

=DOLLARFR(decimal_price, unit)

Parameters:

decimal_price (required):
The decimal price to convert to a fraction.
unit (required):
The denominator of the fraction to round to, such as 2 for halves or 4 for quarters.

Examples

Here are a few example use cases that explain how to use the DOLLARFR formula in Google Sheets.

Converting Decimal Prices to Fractions

Suppose you have a list of decimal prices and you want to convert them to fractions. You can use DOLLARFR to round each price to the nearest fraction of a dollar.

Formatting Currency in Reports

If you're creating a report that needs to display currency values in a specific format, you can use DOLLARFR to format the values as fractions of a dollar rounded to the nearest unit.

Common Mistakes

DOLLARFR not working? Here are some common mistakes people make when using the DOLLARFR Google Sheets Formula:

Wrong data type for decimal_price parameter

The decimal_price parameter should be a number or a reference to a cell containing a number. If a non-numeric value or a range of cells is provided, the formula will return an error. Double-check that the data type of the decimal_price parameter is correct.

Wrong data type for unit parameter

The unit parameter should be an integer that represents the denominator of the fraction. If a non-numeric value or a range of cells is provided, the formula will return an error. Double-check that the data type of the unit parameter is correct.

Decimal_price is negative

The decimal_price parameter cannot be negative. If a negative value is provided, the formula will return an error. Double-check that the decimal_price parameter is positive.

Unit is zero

The unit parameter cannot be zero. If a zero value is provided, the formula will return an error. Double-check that the unit parameter is a positive integer.

Decimal_price is greater than or equal to unit

The decimal_price parameter must be less than the unit parameter. If a decimal_price value greater than or equal to unit is provided, the formula will return an error. Double-check that the decimal_price parameter is less than the unit parameter.

The following functions are similar to DOLLARFR or are often used with it in a formula:

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.
DOLLARDE
The DOLLARDE function converts a price quotation given as a fraction into a decimal price, and returns the result as a dollar value. This function is commonly used in financial calculations.
FV
The FV function calculates the future value of an investment based on periodic constant payments and a constant interest rate. It takes into account the present value of the investment, the number of periods in which the payments are made, and the compounding frequency. This formula is commonly used in financial planning and investment analysis.
PV
The PV function in Google Sheets calculates the present value of a regular payment stream or a lump sum amount, based on a constant interest rate. It is commonly used in financial analysis to determine the value of investments or loans. This function returns a negative value, as it represents money flowing out from the user.

Learn More

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