View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Malva Malva is offline
external usenet poster
 
Posts: 1
Default Return Value using If statement or Lookup?

I have column a1 thru a100 are pass/fail values, column b1 will return a
"fail" if any of the rows in column a1:a100 has a "fail" value. Do you have
a if statement I can use?