EVEN function in Excel

What is EVEN function in Excel?

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

The EVEN function Rounds a positive number up and a negative number down to the nearest even integer.

We can find this function in the Math & Trig category of the insert function Tab.

How to use EVEN function in excel

  1. Click on an empty cell (like F5 )
empty cell in excel
  1. 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 EVEN function

6. Then select ok

math and trig function category in excel

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

8. Number section is the value to round (for example 1.5)

9. If you enter +1.5 result will be 2

even function in excel

10. If you enter 2.5 result will be 4

even function in excel

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

even function in excel

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

even function in excel

13. You will see the results in the formula result section

Things to Remember

  • The argument of this function is number
  • The argument of this function is required and not optional
  • This function is available for all excel versions(2007-2019)

Examples of EVEN function in excel

Example 1:

How to use EVEN function in excel

You can see examples of EVEN function below:

Examples of EVEN function in excel
even(0.5) ----->>>>answer is  2

even(1.5) ----->>>>answer is  2

even(-1.5) ----->>>>answer is  -2

even(-0.5) ----->>>>answer is  -2

even(0) ----->>>>answer is   0

What is the purpose of EVEN function?

The EVEN function Rounds a positive number up and a negative number down to the nearest even integer.

What is the Return value of EVEN function?

It returns a number.

How many arguments does EVEN function have?

This function has just 1 Argument.

The argument of EVEN function is number.

Number section is the value to round (for example 1.5).

The argument of EVEN function is required and not optional.

EVEN(number) = number

Which version of excel supports EVEN function?

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

Errors in EVEN function

EVEN related functions :

Leave a Reply

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