The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function is set to **always round down**. This is important to remember.

**Syntax:**

=FLOOR(number, multiple)

**Arguments:**

**number**– The number that should be rounded.**significance (multiple)**– Specified multiple when rounding down.

**FLOOR Function Example**

Let’s look at the following examples.

**Rounding Functions in Excel**

ROUND Function – Rounds to a specified number of digits.

ROUNDUP Function – Rounds numbers up a specified decimal place.

ROUNDDOWN Function – Returns a number rounded down to a specified number of places.

FLOOR Function – Rounds a given number down to the nearest specified multiple

MROUND Function – Round a number up or down to a given multiple.

CEILING Function – Rounds a given number up to the nearest specified multiple.

INT Function – Rounds a number down to the nearest integer.

TRUNC Function – Returns a truncated number based on a specified number of digits.