Excel EVEN and ODD Function

Today we will learn about Excel EVEN and ODD function. These functions help us to round up a number to nearest Even Number and nearest Odd number.

1) EVEN (number): To round up the number to nearest even integer.

2) ODD (number): To round up a number to the nearest Odd integer.

To determine the nearest even/odd value:

  1. In cells B4:B10 Some numbers are mentioned.
  2. Select cells C4:C10 and enter the following function: EVEN (B4)
  3. Press <Ctrl + Enter>
  4. Select cells D4:D10 and enter the following function: ODD(B4)
  5. Press <Ctrl + Enter>

 

 

 

 

 

 

Kindly share your feedback in comments

Be the first to comment

Leave a Reply

Your email address will not be published.


*