Hi Group,
The following formula works fine but is a bit long, particularly as I will
have to
expand it to comparing 10 or 12 values in the future. Does anyone know of a
way to shrink it to something more usable and flexible.

=IF(C15=0,"",IF(AND(C15>=D15,C15<=E15,F15>=$M$7,
F15<=$N$7,G15>=H15,G15<=I15,J15>=$M$7,J15<=$N$7),"PASS","FAIL"))

What it does is take 4 values (C15,F15,G15 and J15) and compare each against
a different upper and lower limit, if all are within their limits then
"pass" if one misses
then "fail".

Thank you for any help,
Martin