multiple if-and function

[leah_v]

I am new to excel. I am trying to write a function with 3 conditions, but it does not work. Could you please help me to figure out what error I do?

=IF(AND(A1=1, ISBLANK(B1)),C1=1,IF(AND(A1=2, B1=1),C1=2,IF(AND(A1=2, B1=2),C1=0)))

What I am trying to say: if in column A value is 1 and column B is empty cell, then C should be 1, if column A is 2 and Coulmn B is 1, then C should be 2. Finally, if both columns are 2 then C should be 0.

Thank you for your time!!

 

[T. Valko]

I am new to excel. I am trying to write a function with 3 conditions, but it does not work. Could you please help me to figure out what error I do?

=IF(AND(A1=1, ISBLANK(B1)),C1=1,IF(AND(A1=2, B1=1),C1=2,IF(AND(A1=2, B1=2),C1=0)))

What I am trying to say: if in column A value is 1 and column B is empty cell, then C should be 1, if column A is 2 and Coulmn B is 1, then C should be 2. Finally, if both columns are 2 then C should be 0.

Thank you for your time!!

This formula entered in C1:

=IF(AND(A1=1,B1=""),1,IF(AND(A1=2,B1=1),2,IF(AND(A1=2,B1=2),0,"")))

 

[leah_v]

It worked just fine! Many-many thanks. T. Valko, for your time. I still try to see what wrong I did, so taht I learn something. Was the problem in referreing to the column C, while I needed just to put the value?

 

[T. Valko]

It worked just fine! Many-many thanks. T. Valko, for your time. I still try to see what wrong I did, so taht I learn something. Was the problem in referreing to the column C, while I needed just to put the value?

Yes, that was the problem.

Also, at the very end of the formula you needed to define what to return if NONE of the conditions was met. I have the formula return a blank "".

 

[leah_v]

Got it--thank you! I learned something new today. Have a great day!

 

[T. Valko]

Got it--thank you! I learned something new today. Have a great day!

You're welcome. Thanks for the feedback!