Forum Discussion
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 differenc...
Detlef_Lewin
Mar 26, 2018Silver Contributor
Jantine,
=COUNTIFS(A1:B1,">0",A1:B1,"<4")=2