FLOOR

Definition: FLOOR is a function that rounds a number down to the nearest specified multiple.

Syntax: =FLOOR(number, significance)

Situation: This formula is suitable when you need to round a number down to the nearest specified multiple.

Example: If you have a number 3.5 and want to round it down to the nearest multiple of 2, the formula =FLOOR(3.5, 2) can be used, which returns 2.