Forum Discussion
Help formula
Hi, I want to make my live easier. So I'm trying to create a formula in Excel. I have no idea how to get all conditions in my formula : =IF(OR(A2=2;A2=9);IF(E2>4;B2);IF(OR(E2>0;E2<5);B2/2;IF(E...
Another variant could be
=0.5*B2*(E2>0)*(1+(E2>((A2=22)+2*(A2=23)+4*((A2=2)+(A2=9)))))