EVEN Function in Excel

In this post, you will learn about Even function in Excel, how to use it with-in excel spreadsheet.

How does the EVEN Function work?

The Even function rounds up the given number to the nearest even number.

Syntax

=EVEN(number)

The Syntax has a single argument:

number – This argument holds the number to be rounded up.

How to use EVEN Function in Excel?

• Open a document with the required data or enter the numbers.

• In a new cell enter the syntax of the Even function and highlight the cell containing the number to include it in the syntax.

• Press enter to display the answer.

• Use the fill handle to apply the syntax to the remaining data.

Important points:

• The syntax does not consider the sign of the number, whether positive or negative.
• If the given number is an even number, the syntax returns the same value.

• It always rounds up the number away from zero, that is to the next greater even number.
• The syntax returns the value #VALUE!, when the number is a non numeric value.