Check Sheet Logo
Check Sheet

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:

=FLOOR.PRECISE(number, [significance])
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.

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

Learn More

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