View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claudio
 
Posts: n/a
Default Printing with formula

I am trying to check the value of a range of cells and print PASS or Fail,
depending if all the cells fall within those parameters or not.
This is what I am using:

=IF(AND(A590:J590<41, A590:J59033),"PASS","FAIL")

It seems that it only checks the first cell, A590. If I change the value of
any of the other cells, it doesn't work.
--
Claudio