INT Excel Formula

Author Zaheer    Category Formulas     Tags ,

Microsoft Excel is widely used in the field of mathematics since this software program is equipped with lots of mathematical functions. Excel can make your life easier particularly when you are working with mathematical problems. It can perform calculations from the simplest up to the complex mathematical computations. One of the functions in Excel that is useful in mathematics is the INT function. This is used to round down a decimal number to the nearest integer. You need to read this article if you want to learn more about the INT functions. A good way to start with the topic is to know the basic description of the function. So, what is INT function?

Overview of INT Function in Excel

The INT Function in Microsoft Excel rounds a given numerical value down to the nearby integer below. This function is the same as the ROUNDDOWN function which is utilized to decrease the number of decimal places of a number. What makes the difference is that, it always eliminates all the decimal places ending up with a whole number. The formula of the INT function is:

INT (number)

In this formula, the number row is a required argument and it refers to the number that you want to reduce down to the nearby integer below. This argument can be supplied either as a value that is returned from other formula or functions, a cell reference which contain the numerical value, or as the actual numerical value.

You have to take note of the fact that the INT function in Excel always rounds up a numerical value. If you wish to round to the closest whole number (up or down), you require to utilize the MROUND function or ROUND function.

Examples on How to Use the INT Function in Microsoft Excel

  • Let’s say that a numerical value of 100.9 is contained in cell A1. Then type in this formula in any cell where you want the result to appear, =INT (A1). Then function will return the result which is 100.
  • For instance, a numerical value of 5.22 is contained in cell A2. Then enter this formula in any cell, =INT (A2). The function will return the result which is 5.
  • Here’s another one, 99.5 is contained in cell A3. You can use this formula, =INT (A3). Then the function will return the result which is 99.
  • Let’s take a look if negative numerical values are supplied in the formula of the INT function. As an example, a numerical value of -6.1 is contained in cell A4. Type in this formula in any cell where you want the answer to be displayed, =INT (A4). The function will return the result which is -7.
  • Finally, take for instance that -100.9 is contained in cell A5. You can use this formula, =INT (A6). The function will return the result which is -101.

As you can see in the examples given above, the INT function always rounds downwards a supplied numerical value. Even with numbers that carry a negative sign, the function encompasses to the whole number equal or below the supplied numerical value. You can try the examples in your blank Excel spreadsheet so you can learn more about the usage of the INT function in Microsoft Excel.

Post comment