IF Functions

A

ALex

What type of folmula would respond to the following conditions:

IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555
IF Any Cell in Column AA= A2 and Any Cell Column AB =B1 then C1=666

IF Any Cell in Column AA= A1 and Any Cell in Column AB =B2 then C1=444
IF Any Cell in Column AA= A2 and Any Cell in Column AB =B2 then C1=777

help me please?

Alex
 
D

Domenic

Try...

=IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B1),555,IF(COUNTIF(AA:AA,A2)*COUNTIF(
AB:AB,B1),666,IF(COUNTIF(AA:AA,A1)*COUNTIF(AB:AB,B2),444,IF(COUNTIF(AA:AA
,A2)*COUNTIF(AB:AB,B2),777,""))))

Hope this helps!
 
Top