FLOOR.MATH function
Number
The number to be rounded.
Significance
The multiple to which the input number should be rounded. If omitted, it is assumed to be 1.
Mode
0 if the number should be rounded toward zero and 1 if the number should be rounded away from zero. If omitted, it is assumed to be 0.
Returns
The rounded number.
Returns a number rounded down to the nearest multiple of another number. FLOOR.MATH(22)FLOOR.MATH(22) and FLOOR.MATH(22.1)FLOOR.MATH(22,1) both return 22.
If a significance is not specified, it is assumed to be 1, meaning that the returned value is an integer. FLOOR.MATH(22.1, 5)FLOOR.MATH(22,1; 5) returns 20, because 20 is the nearest multiple of 5 that 22.1 can be rounded down to.
Negative numbers are rounded towards zero by default. That means that FLOOR.MATH(-22.1, 5)FLOOR.MATH(-22,1; 5) returns -25, not -20. The third parameter may be used to customize this behavior. FLOOR.MATH(-22.1, 5, 1)FLOOR.MATH(-22,1; 5; 1) returns -20, not -25.
Examples
Returns 22, assuming a significance of 1.
Returns 22, assuming a significance of 1.
Returns 22, with the significance given as the second parameter.
Returns 20, with the significance given as the second parameter.
Returns -20, because the third parameter is set to a value that causes negative numbers to be rounded away from zero.
Returns the array { 22, 22 }{ 22; 22 }.
Returns the array { 22, 22 }{ 22; 22 }.
Returns the array { 20, 20 }{ 20; 20 }.
Returns the array { 20, 22 }{ 20; 22 }. 22 uses a significance of 5 and 22.1 uses a significance of 1.