Excel - formula
Posted on 2011-09-21
My OS is windows 7 and I am using Excel 2007. I would like to know how to achieve this :
Say in Col A, I have 20800. and in Col B 20898 and the numbers are to be Even.
I would like to find out what formula to use, say in Col C, to get all the even numbers from 20800 to 20898, just a count only of how many even numbers are in that range..
Another problem is , say in Col A the number is 20801 and in Col B 20899 and the numbers are to Odd. I would like to find out the same time of formula as above, but for Odd numbers, and again a count only of all the ODD numbers in this range. .
As I have more numbers to run thus to see if I can do it the smart way. thank u.