if statements

[BernardH]

I have 3 columns (A1, B1,C1). The object is to return "Call" in A1 if the value of B1 is <= 14 (I have that one figured out). I would like to return "Rank" in A1 if C1 is not empty (in this case, containing a date). I have tried using: =IF(B1<=14,"Call",IF(C1>0,"Rank,"")) which will work for the first IF but I can't get the second IF to work. Any help would be greatly appreciated.

Bernard

 

[kmillen]

Which action has priority? I mean, do you wish to check is C1 is not empty only if B1 > 14 or vice versa?

What happens if B1 <= 14? Then does C1 get checked?