Thursday, November 3, 2011
Odds and Evens
When working with databases or tables, there are many instances when you wish to Identify and Sort whether the number is Odd or Even. Cases may involve street addresses, employee ID numbers, statistical studies, and several other pursuits.
So what is a Good Formula for identifying an Odd or Even number? As with so many things in Excel, there are several ways to do this, but the following are among the most straight-forward. Assuming your data is in Column A, you could use this formula and copy down your range:
1. =IF((ISEVEN(A1) = TRUE), "Even", "Odd") This IF formula incorporates the ISEVEN function to generate the desired results.
~ Or ~
2. =IF(MOD(A1,2)=0,"Even","Odd") This IF formula incorporates the MOD function to generate the results. MOD is an unusual function that finds the Remainder when you divide one figure by another.
Odds and Evens: There are times when knowing this information can be a Boon to your data analysis needs.