Explanation

TheROUNDDOWN functionrounds a numberdownto a given number of places.

The number of places is controlled by the number of digits provided in the second argument (num_digits).

At each step, numbers that would normally be rounded up are rounded down.

Excel formula: Round a number

you might use theFLOOR functionto round a number down to a given multiple.

Unlike standard rounding, where only numbers less than 5 are rounded down, ROUNDDOWN roundsall numbers down….

Excel formula: Round a number up

Excel ROUNDDOWN function