View Single Post
  #2   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

One way...

format the font in C1 to Webdings, then use the following formula in
C1...

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

"a" in Webdings is a tick, while "r" is a cross.

The formula results in a blank when either A1 or B1 are blank.

Ken Johnson