FLOOR
What Does It Do?
This function rounds a value down to the nearest multiple specified by the user.
Syntax
=FLOOR(Number To Round, SignificantValue)
Formatting
No special formatting is needed.
| Number | Rounded Down | |
| 1.5 | 1 | =FLOOR(C4,1) |
| 2.3 | 2 | =FLOOR(C5,1) |
| 2.9 | 2 | =FLOOR(C6,1) |
| 123 | 100 | =FLOOR(C7,50) |
| 145 | 100 | =FLOOR(C8,50) |
| 175 | 150 | =FLOOR(C9,50) |
Example:
The following table was used to calculate commission for members of a sales team. Commission is only paid for every £1000 of sales.
The =FLOOR() function has been used to round down the Actual Sales to the
nearest 1000, which is then used as the basis for Commission.
| Name | Actual Sales | Relevant Sales |
Comm- ission |
| Alan | £23,500 | £23,000 | £230 |
| Bob | £56,890 | £56,000 | £560 |
| Carol | £18,125 | £18,000 | £180 |
| =FLOOR (D29, 1000) |