Thread: help with a IF formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CurlerBob CurlerBob is offline
external usenet poster
  
Posts: 8
Default help with a IF formula
Try this:

=IF(ISNA(MATCH(2,A4:AF4,0)),"fail","pass")
Reply With QuoteReply With Quote