answer:The format of an IF() is: IF(CONDITION,VALUE_IF_TRUE,VALUE_IF_FALSE) In your case, all you need to do is make your VALUE_IF_FALSE be another IF() statement. So: [equal]IF(A1[equal]“A”,A2*B1,IF(A1[equal]“B”, A2*B2, IF(A1[equal]“C”, A2*B3, A2*B4))) The final value is the last “else”. It’s what goes in the cell if none of the conditions are true. Unfortunately, Excel (at least the 2000 version, don’t know about 2007) has a hard limit to the number of levels you can do this. I think that level is 7, but I’m not 100% sure.