FLOOR function

FLOOR(Number, Significance?) FLOOR(Number; Significance?)

Number

Number or { Number }

The number to be rounded.

Significance

Number or { Number } (optional)

The multiple to which the input number should be rounded. If omitted, it is assumed to be 1.

Returns

Number or { Number }

The rounded number.

Returns a number rounded down to the nearest multiple of another number. FLOOR(22)FLOOR(22) and FLOOR(22.1)FLOOR(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(22.1, 5)FLOOR(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, unless both parameters are negative, in which case numbers are rounded away from zero. That means that FLOOR(-22.1, 5)FLOOR(-22,1; 5) returns -25, not -20. Use FLOOR.MATH instead to customize this behavior.

Examples

FLOOR(22)FLOOR(22)

Returns 22, assuming a significance of 1.

FLOOR(22.1)FLOOR(22,1)

Returns 22, assuming a significance of 1.

FLOOR(22.1, 1)FLOOR(22,1; 1)

Returns 22, with the significance given as the second parameter.

FLOOR(22.1, 5)FLOOR(22,1; 5)

Returns 20, with the significance given as the second parameter.

FLOOR(-22.1, 5)FLOOR(-22,1; 5)

Returns -25, because negative numbers are rounded toward zero. Use FLOOR.MATH instead to customize this behavior.

FLOOR({ 22, 22.1 })FLOOR({ 22; 22,1 })

Returns the array { 22, 22 }{ 22; 22 }.

FLOOR({ 22, 22.1 }, 1)FLOOR({ 22; 22,1 }; 1)

Returns the array { 22, 22 }{ 22; 22 }.

FLOOR({ 22, 22.1 }, 5)FLOOR({ 22; 22,1 }; 5)

Returns the array { 20, 20 }{ 20; 20 }.

FLOOR({ 22, 22.1 }, { 5, 1 })FLOOR({ 22; 22,1 }; { 5; 1 })

Returns the array { 20, 22 }{ 20; 22 }. 22 uses a significance of 5 and 22.1 uses a significance of 1.