Round a number down to the nearest specified multiple
A rounded number.
=FLOOR (number, multiple)
- number – The number that should be rounded.
- multiple – The multiple to use when rounding.
FLOOR works like the MROUND function, but FLOOR always rounds down toward zero.
The FLOOR function can be a good way to can be a good way to set pricing after currency conversion, discounts, etc.