Back to all functions

In this lesson we are going to go through the EVEN and ODD functions, which return the next Even or Odd whole number, respectively.
Both functions consist of only one argument: The number which we want to have changed to the next Even or Odd number.
So for even, we’ll write Equals, EVEN, and select our number. We get the number 98, which is the next even number after 96. If we change the number to a negative, we can see that it rounds the number down instead, to negative 98.
To get the next Odd number, we write Equals, ODD, and select the number. The result changes to the number 97, which is the next Odd number after 96. Same thing applies if we change the original number to a negative.
In this lesson we have taken a look at the EVEN and ODD functions, which round numbers up to the nearest even or odd integer.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.