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.
*where “variable/number” are the numbers to be rounded up to an even integer
Figure 1: Excel EVEN function
In the figure above, the formula in cell D9 is:
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.
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.