FLOOR
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) |
What Does It Do?
This function rounds a value down to the nearest multiple specified by the user.
Syntax
=FLOOR(NumberToRound,SignificantValue)
Formatting
No special formatting is needed.
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 | Commission |
Alan | £23,500 | £23,000 | £230 |
Bob | £56,890 | £56,000 | £560 |
Carol | £18,125 | £18,000 | £180 |
=FLOOR(D29,1000) |