DOLLARFRfunction 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
- Examples of using
DOLLARFRformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
DOLLARFRformula 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.
DOLLARFRnot working? Here are some common mistakes people make when using the
DOLLARFRGoogle 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:
DOLLARfunction 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.
DOLLARDEfunction 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.
FVfunction 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.
PVfunction 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.
You can learn more about the
DOLLARFR Google Sheets function on Google Support.