Excel and MS Office
FLOOR.MATH Function in Excel – Complete Guide with Examples
FLOOR.MATH Function in Excel – Complete Guide with Examples
Introduction
The FLOOR.MATH function in Excel is used to round numbers down towards the nearest integer or a specified multiple.
It is especially useful in financial calculations, inventory management, pricing, and other data analysis tasks where downward rounding is required.
In this blog, we’ll explain its syntax, arguments, examples, and use cases to help you understand the function better.
Syntax
Arguments
-
number (Required) → The numeric value you want to round down.
-
significance (Optional) → The multiple to which you want to round down.
If omitted, Excel uses 1 by default.
-
mode (Optional) → Controls the direction of rounding for negative numbers.
How FLOOR.MATH Works
The FLOOR.MATH function always rounds down to the nearest multiple of the significance you provide.
Examples
Example 1 – Basic Rounding
Result: 7
Explanation: Since significance is not defined, Excel rounds down to the nearest integer.
Example 2 – Rounding Down to a Multiple
Result: 25
Explanation: Rounds down 27 to the nearest multiple of 5.
Example 3 – Negative Numbers (Default Mode)
Result: -8
Explanation: Rounds negative numbers down away from zero.
Example 4 – Negative Numbers (Mode = 1)
Result: -6
Explanation: Rounds negative numbers toward zero.
Common Errors
| Error |
Reason |
Solution |
#VALUE! |
Non-numeric value entered |
Ensure you use numbers only |
#DIV/0! |
Significance is 0 |
Use a non-zero value |
| Wrong rounding |
Significance negative |
Use positive significance |
Real-Life Use Cases
-
Finance: Rounding down currency values
-
Inventory Management: Rounding stock to pack sizes
-
Construction: Rounding down material measurements
-
Pricing: Setting discount slabs or rounded prices
FLOOR.MATH vs FLOOR Function
| Feature |
FLOOR.MATH |
FLOOR |
| Negative numbers |
More control |
Less control |
| Mode argument |
✅ Yes |
❌ No |
| Availability |
Excel 2013+ |
All versions |
