IF Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

up to 7 functions? 10
complex sort search and replace macro 2
COPYING FORMULAE 1
Re counting 9
Nameing a function 1
lastrow function help 6
Hiding columns in Excel 2003 2
functions 3

Back
Top