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
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
Formula
When Significance value is negative and Number is Positive it results in #NUM! error so the result will be
Result
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