IF, AND, OR nesting help- Can you help me write this function?

[agf12555]

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!

[benishiryo]

hi agf12555. try:
=SUMIF(A1:B1,">1")>0