Author: Oscar Cronquist Article last updated on May 04, 2022

The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance.

1. FLOOR Function Syntax

FLOOR(number, significance)

Back to top

2. FLOOR Function Arguments

number Required. The number you want to round.
significance Required. The multiple to which you want to round.

Back to top

3. FLOOR Function Example

Formula in cell C3:

=FLOOR(B3, 2)

Back to top

Excel 'Round' functions


CEILING function
Rounds a number up to its nearest multiple.
EVEN function
Rounds a number up to the nearest even whole number.
FIXED function
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
FLOOR function
Rounds a number down, toward zero, to the nearest multiple of significance.
FLOOR.MATH function
Rounds a number down to the nearest integer or to the nearest multiple of significance.
FLOOR.PRECISE function
Rounds a number down to the nearest integer or nearest multiple of significance.
INT function
Removes the decimal part from positive numbers and returns the whole number (integer) except negative values are rounded down to the nearest integer.
MROUND function
Calculates a number rounded to a given multiple.
ROUND function
Rounds a number based on the number of digits you specify.
ROUNDDOWN function
Rounds a number down based on the number of digits to which you want to round the number.
ROUNDUP function
Calculates a number rounded up based on the number of digits to which you want to round the number.
TRUNC function
Removes the fractional part of the number to an integer.
Excel Function Reference
Provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas.