Determining Whether a Value is Odd or Even
Posted by David Holstein on January 16, 2002 12:02 AM
I need to determine whether a PARTICULAR day is ODD or EVEN. In cell A1 I have =DAY(TODAY()) which generates the number for that day. From there I need to point a formula to they cell to determine Odd or Even. I have considered a series of IF formula's, but am troubled by the fact that there is limitation of 7 IF statements in one formula.
I simply want the formula to equate to either ODD or EVEN.
Does anybody know of a better solution. Any help much appreciated.