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 ,
Bookmarks