Thread: help with a IF formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
nadine nadine is offline
external usenet poster
  
Posts: 216
Default help with a IF formula
No they have changed the criteria.

If specific cells containt a 2

K4,L4,P4,Q4,T4,U4,X4


"CurlerBob" wrote:

Try this:

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