This is the formula I've come up with

=IF(AND(ISNUMBER(SEARCH("ASM",A4))),"1",IF(AND(ISN UMBER(SEARCH("ASM",A6)),"1","")))


I basically want to look at 2 cells and if they both contain ASM I want to place a 1 in col B if not then it can be blank or na or anything other then a 1.

Any suggestions how to fix this?