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(I40,K4=x),200,IF(AND(I40,J40,L=YES),J4 *1.5,0))
I get #NAME?
can someone help me get this right please?