Excel FLOOR Function

Excel FLOOR Function


Round a number down to the nearest specified multiple

Return value 

A rounded number.


=FLOOR (number, multiple)


  • 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.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas