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.

Leave a Reply

COUNTIFS Function

The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1, [range2], [criteria2], …)

Read More »

ISOWEEKNUM Function

The Excel ISOWEEKNUM function takes a specified date and returns a week number (1-54). The returned week follows the ISO

Read More »

INDEX Function

INDEX Function in Excel The Index Function in Excel returns the value of an array given a specific row and

Read More »
Scroll to Top