Hi, thanks for helping. This is my scenario.....
Column A Column B Column C
Row 1 1 2 IF either A1 or B1 are greater than 1, ignoring the N/A, then TRUE, IF not, then FALSE.
Row 2 N/A 3 IF either A2 or B2 are greater than 1, ignoring the N/A, then TRUE, IF not, then FALSE.
Row 3 N/A 1
It seems that when an N/A is present, the statements I am writing return "True" when it should be false, or vice versa.
Thanks a million!
Bookmarks