=CHOOSE(IF((G2>0;D2>0;G2-D2>0);1;IF(AND(G2>0;D2>0;G2-D2=0);2;IF(AND(G2>0;D2>0;G2-D2<0);3;IF(AND(G2=0;D2>0);4;IF(AND(J2>0;G2=0;D2>0);5;IF(AND(G2>0;D2=0);6;7))))));N2;N3;N4;N5;N6;N7;"hata")
The above formula is to branch the if statement to one of N? according to values of G2,D2 and J2.
It doesnt work and I cannot make it, why???
Please help...
The above formula is to branch the if statement to one of N? according to values of G2,D2 and J2.
It doesnt work and I cannot make it, why???
Please help...