in cell A4 put
=IF(A2=A3,"","Refer to Underwriting")
basically says "If A2 is the same as A3 say "nothing", otherwise say "Refer to underwriting"
or I think you can say
if(A2<>A3,"Refer to underwriting"
which means, "if it doesn't equal the same as"
Bookmarks