functions

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

Guest

How would one include the following conditions in a folmula

IF Column A= A1 and Column B =B1 then C1=1
IF Column A= A2 and Column B =B1 then C1=2

IF Column A= A1 and Column B =B2 then C1=4
IF Column A= A1 and Column B =B3 then C1=5

etc...
 
Hi Alex

not sure what you mean by column A = A1
do you mean every value in column A being the same as the value in A1?

Cheers
JulieD
 
Hi Julie,

I should have clarified - one worksheet vs. the other...

IF Input! Column A= A1 and Input! Column B =B1 then C1=1
Thanks,
Alex
 
How about something like:

=if(and(input!a1=$a$1,input!b1=$b$1),1,if(input!a1=$a$2,input!b1=$b$1),2,
if(and(input!a1=$1$1,input!b1=$b$2),4,if(and(input!a1=$a$1,input!b1=$b$3),5,"error"))))
 
Back
Top