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