Excel FLOOR Function is a tool that helps you round a number down to the nearest multiple of a specified value. This is especially useful when you want to work with numbers in a clean and organized manner. Let’s break it down in simple terms so even a high school student can understand.
Syntax
=FLOOR(number, significance)
Arguments
Here’s what the arguments mean:
| number | The number you want to round down. |
| significance | The value to which you want to round the number down. It’s the multiple to which you want to align your number. |
How to Use
Let’s see how to use the FLOOR function with some examples:
Example 1: You have the number, 17, and you want to round it down to the nearest multiple of 5. Use the FLOOR function like this:
|
1 |
=FLOOR(17, 5) |
This will give you the result: 15 because 15 is the largest multiple of 5 that’s less than or equal to 17.
Example 2: Let’s say you have a decimal number, 8.7, and you want to round it down to the nearest whole number. Use the FLOOR function like this:
|
1 |
=FLOOR(8.7, 1) |
The result will be 8 because it rounds down to the nearest whole number (1 in this case).
Example 3: Now, if you have a negative number, -25, and you want to round it down to the nearest multiple of 10, you can use FLOOR like this:
|
1 |
=FLOOR(-25, 10) |
It will give you -30 because it’s the largest multiple of 10 that’s less than or equal to -25.
Remember that the FLOOR function is handy when you need to simplify your numbers and make them more manageable, especially in financial calculations or when working with data that needs to be grouped or categorized neatly.