FLOOR.PRECISE
TheFLOOR.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 asis. 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.
 How to use
FLOOR.PRECISE
formula?  Examples of using
FLOOR.PRECISE
formula FLOOR.PRECISE
formula not working? Similar formulas to
FLOOR.PRECISE
Usage
Use the FLOOR.PRECISE
formula with the syntax shown below, it has 1 required parameter and 1 optional parameter:
 number (required):
The number to be rounded down to the nearest multiple ofsignificance
.  significance (optional):
The multiple to whichnumber
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 theFLOOR.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 5minute 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 nonnumeric argument
FLOOR.PRECISE requires a numeric value as the number argument. If a nonnumeric 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.
Related Formulas
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 theplaces
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 requiredvalue
parameter and an optionalplaces
parameter specifying the number of decimal places to round to.
Learn More
You can learn more about the FLOOR.PRECISE
Google Sheets function on Google Support.