Forum Discussion

Jantine Lubbers's avatar
Jantine Lubbers
Copper Contributor
Mar 26, 2018

Excel If then else support

Hi! 


Is it possible to make an 'if then else' formula what is true for 2 (out of 7! possibilities)? In my file i use text in cells instead of numbres. But i think it should not make any difference

 

Small example: 

A and B can be 1 till 9

Rule: Only the combinations 'A=1&B=1 or A=2&B=2 or A=1&B=2 or A=2&B=1 are true. 

 

I think the formula should be: =if(and(A1=1;B1=1)*or(and(A1=2;B1=2));true;false) 

also i tried: 
=if(and(A1=1*or(A1=2);B1=1*or(B1=2))

 

But for some reason it isn't working :( 

 

Please, could someone help me? 

 

Kind regards, 

Jantine