P
Pam @ Joyce
I am trying to say if I4 has something in it and K4=X, then put 200 in this
field, but if not see if I4 has something in it and J4 >0 and L= YES then
times J4 by 1.5, if not put 0. my formulae is
=+IF(AND(I4>0,K4=x),200,IF(AND(I4>0,J4>0,L=YES),J4*1.5,0))
I get #NAME?
can someone help me get this right please?
field, but if not see if I4 has something in it and J4 >0 and L= YES then
times J4 by 1.5, if not put 0. my formulae is
=+IF(AND(I4>0,K4=x),200,IF(AND(I4>0,J4>0,L=YES),J4*1.5,0))
I get #NAME?
can someone help me get this right please?