functions
 

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


"ALex" wrote:

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 Julie,

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

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

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

Thanks,
Alex


"JulieD" wrote:

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


"ALex" wrote:

How would one include the following conditions in a folmula


etc...

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"))))

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"ALex" wrote in message
...
Hi Julie,

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

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

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

Thanks,
Alex


"JulieD" wrote:

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


"ALex" wrote:

How would one include the following conditions in a folmula


etc...