FLOOR Function
The Excel FLOOR function is used to round a number down to a multiple of significance. For example, you could round a number down to the nearest decimal place, or to the next multiple of 5.
The syntax for the FLOOR function is:
=FLOOR(number,significance)
Argument |
Purpose |
|---|---|
Number |
The number you want to round down |
Significance |
The multiple of sigificance you want to round the number down to. This must match the sign of the number you are using. For example, you cannot round a positive number down to a negative number |
Below are examples of the FLOOR function being used to round numbers down to various multiples.
Function |
Result |
|---|---|
=FLOOR(A1,0.1) |
5.3 |
=FLOOR(A2,1) |
2 |
=FLOOR(A3,0.1) |
4.5 |
=FLOOR(A4,5) |
20 |
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
