How do I use FLOOR in Excel?
Use FLOOR when you want to round down to a chosen multiple. Enter Number, Significance in that order, then add optional arguments when needed.
Excel Function
FLOOR
Rounds number down to nearest multiple.
FLOOR(number, significance)Arguments
number
RequiredSpecify a single cell reference.
significance
RequiredEnter a numeric value.
Practice Preview
Use FLOOR to return the result with these settings (Number: D2 (cell D2 (Amount in column D)), Significance: 10).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=FLOOR(D2, 10)Result
360
Practice This Function
FLOOR FAQ
Where can I practice FLOOR?
Use the "Start Function Practice" button to jump straight into FLOOR drills.
What arguments does FLOOR use?
The main arguments are Number, Significance. Enter them in order.