How to use the Excel EVEN function

EVEN Function in excel as the name suggests it rounds any given number to its even value, the number can be both negative or positive, so for example if the given input is =EVEN(-1.5) the rounded result will be -2, and if the given input is =EVEN(1.5) then the result is 2 this is an inbuilt function in excel and the keyword to use this function is =EVEN( with a number provided as an argument.

Syntax: =EVEN(number)

The EVEN function syntax has the following arguments:

  • Number (required argument): This is the value we wish to round to the nearest even number.

Example: Let’s look at some Excel EVEN function examples and explore how to use the EVEN function as a worksheet function in Microsoft Excel:

Excel EVEN function 1 - How to use the Excel EVEN function

Syntax:  =EVEN(A27)

Result:

Excel EVEN function - How to use the Excel EVEN function

Based on the Excel spreadsheet above, the following EVEN examples would return:

Syntax: =EVEN(A28)
Result: 2

Syntax: =EVEN(A29)
Result: 2

Syntax: =EVEN(A30)
Result: 2

Syntax: =EVEN(A31)
Result: 4

Syntax: =EVEN(A32)
Result: -2

Syntax: =EVEN(A33)
Result: -4

Note: The EVEN function always rounds up to the next even integer, skipping odd integers along the way. Note that negative numbers are rounded “up” away from zero, so they actually become more negative.

READ:  How to use the Excel CEILING function

Add a Comment

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