# FLOOR.PRECISE

The `FLOOR.PRECISE` function returns a number rounded down to the nearest multiple of a given significance. If the number is already a multiple, it is returned as-is. This can be useful when working with financial data or when dealing with measurements that have a fixed scale. The function is similar to `FLOOR`, but with greater precision.

## Usage

Use the `FLOOR.PRECISE` formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:

Parameters:
1. number (required):
The number to be rounded down to the nearest multiple of `significance`.
2. significance (optional):
The multiple to which `number` should be rounded. If omitted, the default value of 1 is used.

## Examples

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

### Rounding prices to the nearest dollar

Suppose you have a list of prices in column A and you want to round them down to the nearest dollar. You can use the formula `=FLOOR.PRECISE(A2, 1)` and copy it down the column to apply it to all prices.

### Rounding time to the nearest 5 minutes

Suppose you have a list of timestamps in column A and you want to round them down to the nearest 5-minute increment. You can use the formula `=FLOOR.PRECISE(A2, "0:05")` and copy it down the column to apply it to all timestamps.

### Calculating quarterly sales

Suppose you have a table of sales data with dates in column A and sales figures in column B. You want to calculate the total sales for each quarter. You can use the formula `=SUMIFS(B:B, A:A, ">="&FLOOR.PRECISE(date, "3/1"), A:A, "<"&EDATE(FLOOR.PRECISE(date, "3/1"), 3))`, where `date` is the date in column A and the quarter starts on March 1st.

### Rounding up to the nearest multiple

Suppose you have a list of numbers in column A and you want to round them up to the nearest multiple of 10. You can use the formula `=CEILING(A2, 10)-10` and copy it down the column to apply it to all numbers.

### Rounding down to the nearest multiple

Suppose you have a list of numbers in column A and you want to round them down to the nearest multiple of 10. You can use the formula `=FLOOR.PRECISE(A2, 10)` and copy it down the column to apply it to all numbers.

## Common Mistakes

`FLOOR.PRECISE` not working? Here are some common mistakes people make when using the `FLOOR.PRECISE` Google Sheets Formula:

### Not providing number argument

One of the most common mistakes when using FLOOR.PRECISE is forgetting to provide the number argument. Without the number argument, the formula cannot calculate the result. To fix this mistake, make sure to provide a number argument.

### Providing non-numeric argument

FLOOR.PRECISE requires a numeric value as the number argument. If a non-numeric value is provided, the formula will return an error. To fix this mistake, make sure to provide a numeric value as the number argument.

### Not providing significance argument

The significance argument is optional in FLOOR.PRECISE. However, if it is not provided, the formula will round the number down to the nearest integer. To fix this mistake, provide a significance argument if rounding to a specific significance is needed.

### Providing negative significance argument

The significance argument in FLOOR.PRECISE must be positive. If a negative value is provided, the formula will return an error. To fix this mistake, provide a positive value as the significance argument.

### Providing too many arguments

FLOOR.PRECISE only requires two arguments: number and significance (optional). Providing more than two arguments will result in an error. To fix this mistake, make sure to provide only the necessary arguments.

The following functions are similar to `FLOOR.PRECISE` or are often used with it in a formula:

• `FLOOR`

The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

• `CEILING`

The `CEILING` function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments.

• `ROUND`

The `ROUND` formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If the `places` parameter is not specified, the formula rounds to the nearest integer.

• `ROUNDUP`

The `ROUNDUP` formula rounds a number up to a specified number of decimal places. It is commonly used to simplify the display of numbers or to perform calculations that require a certain level of accuracy.

• `ROUNDDOWN`

The `ROUNDDOWN` formula rounds a number down to a specified number of decimal places. It is commonly used in financial calculations, such as calculating the total cost of a purchase including tax. The formula takes a required `value` parameter and an optional `places` parameter specifying the number of decimal places to round to.

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