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:
|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.