M
MartinW
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
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