Nested if function

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

Try

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

Replace highlighted with your "Not Direct Entry" tests