View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KarenH
 
Posts: n/a
Default IF statement question

Can someone translate the following IF statement for me?

=IF((A2<"")*(ISNA(MATCH(A2,$A$1:A1,0))),"A","B")

I'm confused abut the first part, specifically the asterisk separating the
two criteria.
Thanks!