Display next even number


How Even function works in MS Excel

The following list of functions can be used to display even number :)


sheet1 : A1=put a number (odd or even)
sheet1 : B1=put a number (odd or even)
sheet1 : C1=put a number (odd or even)
sheet1 : D1=EVEN(SUM(A1:C1))

Here i am using the sum as additional function.


Related Articles

Data Type Guess While Importing Excel using ADO

When we import Excel Data using OLEDB provider, the type of each column will be determined based on the First 8 rows of the Excel. if you have numeric values mixed with text values in the same column then data of the majority type will be considered and takes Null values for the minority data type. If the two types are equally mixed then it will consider as Numeric.

More articles: Excel functions Excel formulas

Comments

Author: Mrs. Meetu Choudhary Nanda12 Jun 2010 Member Level: Gold   Points : 1

Please add some description from now onwards in your resources.

Thanks and regards
Meetu Choudhary
Site Coordinator.

Author: sameera M14 Jun 2010 Member Level: Bronze   Points : 0

Hi Meetu

Thanks for you valuable suggestion

Sameera M



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: