Another IF fx problem here: This one is simple, but for whatever reason, I am screwing something up.
A B C
1 -10 31
2 -7 9
I am trying to write a fx in cell A1 so if B1 is less than or equal to -10 AND C1 is greater than 10, then cell A1 displays "11", and if not, A1 is blank. In the example above, A1 should read "11", and A2 should be blank.
I've tried a variety of IF(AND fx's and IF(IF fx's and I keep screwing something up.
Thanks in advance for your help.
Bookmarks