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
Bernard