FLOOR

Round a number down to the nearest specified multiple

Sponsored Link

FLOOR

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.

Sponsored Link

0 votes. 0 / 5