There is an AND function in Excel that can do that. The formula would look something like: =IF(AND(condition1,condition2),value1,value2) If condition1 and condition2 are both true, then you get value1, otherwise you get value2. And you can drop in another IF statement in place of either of the values. Like: =IF(AND(condition1,condition2),value1,IF(AND(condition3,condition4),value3,value4)) eg: =IF(AND(B2<5,C2<5),"A",IF(AND(B2>10,C2>10),"B","C")) If condition1 and condition2 are both true, then you get value1, otherwise if condition3 and condition4 are true, you get value3, otherwise you get value4.