You cannot use Boolean (AND , OR) with an array formula.
Try this
=IF(SUMPRODUCT(--(A1:A433),--(A1:A4<41))=COUNT(A1:A4),"PASS","FAIL") you
commit it with a simple ENTER; it is not an array formula.
Just change the cell references - I needed something simple to test.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Claudio" wrote in message
...
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