FLOOR Function in Excel

The FLOOR function in Excel rounds a supplied number towards zero, to the nearest multiple of a given number. FLOOR Function takes up two arguments, the Number to be rounded off and significance to which the level of rounding has to be done.


Syntax of FLOOR Function in Excel

FLOOR( number, significance )

number – The Number to be rounded

significance– Multiple of Significance to which the number has to be rounded to


Example of FLOOR Function in Excel


FLOOR Function in Excel 1

When Significance value is negative and Number is Positive it results in #NUM! error so the result will be


FLOOR Function in Excel 2

Note: #VALUE! Error occurs if the supplied arguments are non-numeric.

#DIV/0! Error occurs if the significance argument is Zero

#NUM! Error occurs when Number is Positive and significance value is negative

previous FLOOR Function in Excel                                                                                                           next FLOOR Function in Excel

DataScience Made Simple