# 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.

## Usage

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

Parameters:
1. decimal_price (required):
The decimal price to convert to a fraction.
2. 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.

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