Hi

I'm trying to say that if H2 contains the letters CD and J2 is less than 35000 , then put "EX/EX" , otherwise out M2.

This is the formula I'm tying , but it's not working :

=IF(AND(H2="*CD*",J2<35000),"EX/EX",M2)


It doesn't give an error , but doesn't give correct outcomes either.

Can anyone suggest a solution? Grateful for your advice.


Best Wishes ,