< Go Back

Excel EVEN Function

How to use Excel EVEN function

Just as it is with using other different functions in Excel, there are also several ways to use Excel EVEN function. This post will guide you on how to apply the EVEN function with syntax in Excel.

Syntax

=Even(number)

*where “variable/number” are the numbers to be rounded up to an even integer

EXAMPLE

Figure 1: Excel EVEN function

In the figure above, the formula in cell D9 is:

=EVEN(C9)

and it returned -2.

You could see some examples of numbers and their corresponding outcomes. In addition, each has a note to clearly explain what was done.

Explanation

The Excel EVEN function helps to round up a given number up to the next even value, omitting odd numbers in the process. The function rounds up numbers away from zero, which makes negative and positive numbers become smaller (more negative) and larger respectively.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar