# 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.