Purpose
Round a number down to the nearest specified multiple
Return value
A rounded number.
Syntax
=FLOOR (number, multiple)
Arguments
- number - The number that should be rounded.
- multiple - The multiple to use when rounding.
Usage notes
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.