INT function in Excel

What is INT function in Excel?

The INT function is one of the math functions of Excel.

It Rounds a number down to a Nearest integer.

We can find this function in Math & trig of insert function Tab.

How to use INT function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on the fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select INT  function

6. Then select ok

math and trig function category excel

7. In the function Arguments Tab you will see the INT function

8. In the number section you can enter the value to round (for example 1.5)

9. If you enter +1.5  result will be 1

int function in excel

10. If you enter 2.5 result will be 2

int function in excel

11. If you enter -1.5  result will be  -2

int function in excel

12. If you enter -2.5 result will be -3

int function in excel

13. You will see results in the formula result section

Examples of INT function in excel

Example 1:

How to use INT function in excel

You can see examples of INT function below:

int(2.4) ----->>>>answer is  2

int(1.4) ----->>>>answer is  1

int(0) ----->>>>answer is    0

int(-1.6) ----->>>>answer is  -2

int(-2.6) ----->>>>answer is  -3

What is the purpose of INT function?

It Rounds a number down to a Nearest integer.

What is the Return value of INT function?

It returns a number.

How many arguments does INT function have?

This function has just 1 Argument.

The argument of INT function is number.

In the number section you can enter the value to round (for example 1.5).

The argument of INT function is required and not optional.

INT(number) = number

Which version of excel supports INT function?

This function is available for all excel versions (2003-2019)

Errors in INT function

INT related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *