Hi,

I've got a formula here :

=IF(AND(H5="Direct Entry",CW5<AG5+49,CW5<>""),"Target Met","Breach")

what I'd like to do is now to see if H5 does not = "Direct Entry" then i'd like for it to follow other logical tests which include referring to other columns etc... what is the best way to do this. would appreciate advice

thanks