DOLLARFR
TheDOLLARFR
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:
 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 theDOLLARFR
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 nonnumeric value or a range of cells is provided, the formula will return an error. Doublecheck 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 nonnumeric value or a range of cells is provided, the formula will return an error. Doublecheck 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. Doublecheck 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. Doublecheck 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. Doublecheck that the decimal_price parameter is less than the unit parameter.
Related Formulas
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.