The FLOOR function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the FLOOR function in Excel.
The FLOOR function is used to round down a numerical value to the nearest multiple of significance.
- number: It refers to the number to round down.
- significance: The number to whose multiple you want to round down your number.
A rounded-down version of the input number.
Examples of FLOOR Function
Suppose, you have the number 3.4 in cell A2. You can round down the number to any multiple of significance using the FLOOR function. Suppose, you want to round down 3.4 to the nearest multiple of 3. For that, use the formula:
The output will be 3.
Here are some examples of the usage of the FLOOR function.
Usage Guide of FLOOR Function
Step_1: Start with inserting an equal sign (=) in a blank cell.
Step_2: Then type FLOOR.
Step_3: Type open parenthesis “(“.
As you type the open parenthesis, Excel shows the syntax of the FLOOR function.
Step_4: Insert a number to round down.
You can directly insert a number or a cell address that contains a number.
Step_5: Then insert a comma (,).
After inserting the comma, Excel will ask you for the second argument which is the significance.
Step_6: Now specify the number to whose multiple you want to round down your number.
I want to round down the number to the nearest multiple of 2. So, I have inserted 2 inside the function.
The FLOOR function converts 3.4 into 2. Because here, the significance is 2. The multiples of 2 are 0,2,4,6, etc. The previous nearest multiple of 2 to 3.4 is 2. So the formula returns 2.
- The FLOOR function shows #VALUE! error in the case of the non-numeric values.
- When the number is positive but the significance is negative, the FLOOR function returns a #NUM! error.
- The FLOOR function returns #DIV/0! error, when the significance is 0.
- If the number is an exact multiple of the significance, the FLOOR function doesn’t make any change.
- When both the number and the significance are negative, the FLOOR function rounds upward.
- When the number is negative but the significance is positive the FLOOR rounds downward.
Related Rounding Functions
- ROUND Function ⋙ rounds to the given number of decimal places.
- MROUND Function ⋙ rounds to the nearest specified multiple.
- ROUNDUP Function ⋙ rounds up a numerical value to a specific decimal place.
- ROUNDDOWN Function ⋙ rounds down a numerical value to a specific decimal place.
- CEILING Function ⋙ rounds up a numerical value to the nearest integer or the nearest multiple of significance.
- INT Function ⋙ rounds down a numerical value to the nearest integer number.
- TRUNC Function ⋙ removes specific digits from the fraction part of a number.
The FLOOR function is one of the math and trigonometry functions in Excel. If you have any questions regarding the FLOOR function, please comment below. Thanks!