Hi there,
I have two numbers MJ123 =YES and MJ321=NO the formula seems to work fine with just number but when I place any letters in front it makes no sense,
Thanks in advance
=IF(A1=123,"NO",IF(A1=321,"YES",""))
=IF(D1=MJ123,"NO",IF(D1=MJ321,"YES",""))
Bookmarks