FLOOR Function
The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function is set to always round down. …
significance
CEILING Function
The CEILING function in Excel rounds a given number up to the nearest specified multiple.