# FLOOR.PRECISE Function – Google Sheets

The FLOOR.PRECISE function in Google Sheets rounds a number down to the nearest integer multiple of a specified significance. It rounds negative numbers away from zero.

FLOOR.MATH and FLOOR.PRECISE are intended to supplant the FLOOR function.

## Syntax

`=FLOOR.PRECISE(number, [significance])`

`number` – The number for the function to round

`significance` – Optional. The multiple to round down to. The default value is 1.

## Similar Functions

Several functions deal with rounding. Choose the most appropriate for your use.

• CEILING.MATH – Rounds a number up to the nearest integer multiple of specified significance with customizable negative number treatment
• CEILING.PRECISE – Rounds a number up to the nearest integer multiple of specified significance
• INT – Rounds a number down to the nearest integer
• FLOOR.MATH – Rounds a number down to the nearest integer multiple of specified significance with customizable negative number treatment
• FLOOR.PRECISE – Rounds a number down to the nearest integer multiple of specified significance with customizable negative number treatment
• MROUND – Rounds one number to the nearest integer multiple of another
• ROUND – Round a number to a specified number of decimal places using standard rounding
• ROUNDDOWN – Round a number down to a specified number of places
• ROUNDUP – Round a number up to a specified number of places
• TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits

## Possible Errors

#VALUE! – An argument is non-numeric.

## Examples

You can use FLOOR.PRECISE in many different ways. Let’s take a look at a few, starting with rounding currency.

### Example 1 – Round Down to the Next Nickel

Sometimes, presenting a price rounded down to the next nickel looks more attractive to a customer. Let’s look at how to do that.

The formula used in cell C2: `=FLOOR.PRECISE(A2,B2)`

We use the FLOOR.PRECISE function to round the Original Price to a `significance` of `\$0.05`. Since the function rounds down, it rounds `\$1.23` to \$1.20 in row 2 and rounds `\$1.27` down to \$1.25 in row 4. Google Sheets does not round the value in row 3 because it is already a multiple of `\$0.05`.

### Example 2 – Round Down to the Nearest Half-Hour

Next, let’s round some time values. It is common to refer to a time as a rounded value. In this example, we’ll round values down to the previous half-hour.

The formula used in cell C2: `=FLOOR.PRECISE(A2,B2)`

⚠️ You can enter a half hour as “`0:30`” or “`0:30:00`“. Either way, you’ll need to use custom formatting to remove the seconds, like in the example above in column B.

Rows 2 and 4 both get rounded down to the last half hour. As `1:30 PM` is already a multiple of 30 minutes, the FLOOR.PRECISE function does not change the time in row 3.

### Example 3 – Round With Different Significances

Up to this point, we have been changing the `number`. Now, let’s look at changing the `significance`. We’ll use positive and negative `significances` to see the differences.