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
- How can I best clean my Fleshlight
- How did the United States invade Mexico
- Should bring Papa John's Papa John back
- How does hypolipoproteinemia lead to hemolytic anemia
- Can a widow open an APY account?
- Indore is not as big as Mumbai
- Where is Danny Masterson now
- What is the highest peak on Sumatra
- A factual statement can be wrong
- What is a Norge
- A profit posting in mutual funds is advisable
- What is a LEP license
- What does Shift Reduce mean in parsing
- Women's safety app
- What is Ascension Instructions
- How did the saying Good Night Vienna come about
- What does time mean in the theater
- How to use chmod on Linux
- What is the past participle of baking
- Is a vegetable and meat diet healthy
- What causes a hand fetish
- Why is HCL not given to water?
- Is AVL a binary search tree
- Will space missiles ever be cheap?
- What things are needed in PGDM courses
- How will biotechnology help in my career
- What is the limitation in Tableau Desktop
- How much does the transport cost in China
- Why was Paganini so revered
- How do I get content for blogs
- What does democracy, autocracy or socialism
- Who are some extroverted kpop idols
- Why are my feelings not there
- What is the new product from IBM