View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nadine nadine is offline
external usenet poster
 
Posts: 216
Default help with a IF formula

If any cell in a range of cells A4:AF4 contain the number 2, pass or fail
if a cell contains a 2 want result to show value of fail