Jantine Lubbers
Mar 26, 2018Copper Contributor
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