Guide to using the FLOOR function for rounding down numbers in Excel
Guide to using the FLOOR function for rounding down numbers in Excel: Excel provides users with many functions for rounding numbers to different requirements. In this article, Buffcom.net will introduce you to how to use the FLOOR function to round down to the nearest multiple in Excel.
1. FLOOR function structure
Function syntax: =FLOOR(number; significance)
Where:
- Number: required argument, the number you want to round.
- Significance: required argument, the multiple you want to round to.
Note:
- If the number argument is positive and the significance argument is negative, the FLOOR function returns the #NUM! error value.
- If either argument is not a number, the FLOOR function returns the #VALUE! error value.
- If the sign of the number is positive, the value is rounded down and adjusted towards zero.
- If the sign of the number is negative, the value is rounded down and adjusted away from zero.
- If the number is a multiple of significance, the function will not round further.
2. How to use the FLOOR function
For example, if we need to round 11 down to the nearest multiple of 5. Applying the above function structure, we have the formula:
=FLOOR(11;5)
Guide to using the FLOOR function for rounding down numbers in Excel
Similarly, we have the formula for other cases as follows:
- Round -11 down to the nearest multiple of -5: =FLOOR(-11;-5)
- Round 10 down to the nearest multiple of 5: =FLOOR(10;5)
- Round -11 down to the nearest multiple of 5: =FLOOR(-11;5)
- Round 11 down to the nearest multiple of -5: =FLOOR(11;-5)
We can see that if the number is positive and the significance is negative, the function will return the #NUM! error value. Please note this.
Guide to using the FLOOR function for rounding down numbers in Excel
Therefore, this article has instructed you on how to use the FLOOR function to round numbers down to the nearest multiple in Excel. Good luck to you!
