FLOOR Function Explained
The FLOOR function in Microsoft Excel rounds a number down to the nearest integer or to the nearest multiple of significance. It takes two arguments: the number and the significance. The number is the value to round down, and the significance is the multiple to which you want to round down. For example, FLOOR(4.7, 0.5) would return 4.5.
FLOOR Function Syntax
FLOOR(number, significance)
- number: The number you want to round down to the nearest multiple of significance.
- significance: The multiple to which you want to round down number.