Excel Floor function

Question

I am confused regarding excel floor function. Mathematically, floor (x) is the largest integer not greater than x. Following this definition, I expected, Floor( -3,-2) to display -4 , but it displays -2. Can somebody explain why?

Answer 1

This might help:

FLOOR function - Rounds a number down, toward zero

FLOOR.PRECISE function - Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.

=FLOOR(-3,-2) is -2
=FLOOR.PRECISE(-3,2) is -4