Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelEVEN Function in Excel

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

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021