Rounds a number down to the nearest integer multiple of specified significance.

Parameters

value Number (required) - Number to round down.

significance Number (required) - The number to whose multiples value will be rounded.

Returns

Number

Examples

FLOOR(126.25, 1)

// returns 126
FLOOR(126.25, 10)

// returns 120

Did this page help you?