When to use math

LOWER LIMIT MATHEMATICS (function)

This article discusses the formula syntax and usage of theFLOOR.MATHEMATICS described in Microsoft Excel.

description

Rounds a number down to the nearest whole number or to the nearest multiple of step.

syntax

LOWER LIMIT MATHEMATICS (number; step; mode)

The LOWER LIMIT.MATHEMATICS function syntax has the following arguments:

  • number Required. The number you want to round down.

  • step Optional. The multiple you want to round to.

  • mode Optional. The direction (toward or away from 0) in which to round negative numbers.

Hints

  • By default, positive numbers with decimal places are rounded down to the next lower whole number. For example, if you use the default value for step (1), 6.3 is rounded down to 6.

  • Negative numbers with decimal places are rounded to the nearest whole number opposite 0 by default. For example, -6.7 is rounded to -7.

  • You can change the direction of rounding for negative numbers by using 0 or a negative number for the mode argument. For example, rounding -6.3 with a step of 1 and a mode of -1 rounds towards 0 to -6.

  • The step argument rounds the number down to the nearest integer that is a multiple of the value specified in step. An exception occurs when the number to be rounded is an integer. For example, if you step 3, the number is rounded down to the nearest whole number that is a multiple of 3.

  • If dividing number by a step of 2 or higher results in a remainder, the result is rounded down.

example

Copy and paste the sample data in the following table into cell A1 of a new Excel worksheet. To see the results of the formulas, highlight them, press F2, and then press ENTER. If necessary, you can adjust the width of the columns so that all data is displayed.

formula

Description (result)

Result

= LOWER LIMIT.MATHEMATICS (24.3; 5)

Rounds 24.3 down to the nearest whole number that is a multiple of 5 (20).

20

= LOWER LIMIT.MATHEMATICS (6.7)

Rounds 6.7 down to the nearest whole number (6).

6

= LOWER LIMIT.MATHEMATICS (-8.1; 2)

Rounds -8.1 down (away from 0) to the nearest integer that is a multiple of 2 (-10).

-10

= LOWER LIMIT.MATHEMATICS (-5.5; 2; -1)

Rounds -5.5 down in the direction of 0 to the nearest integer that is a multiple of 2, using a non-0 mode, which is why the rounding direction is reversed (-4).

-4

Top of page