Thread: Make tick appear
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Make tick appear
Oops, I don't know why I put that other And in. Should have been...

=IF(OR(A1="",B1=""),"",IF(A1=B1,"a","r"))

Ken Johnson

Reply With QuoteReply With Quote