I am collecting data for a salt bath temperature comparison. There are three
readings from the salt bath (controller, high and low) and 3 readings from a
test sensor. The test sensor readings are subtracted from the bath readings
and the results are listed in cells J4, K4 and L4. I am allowed +/- 2
degrees difference for the test to be acceptable. In cell M4, I want the
results to show Accept or Reject. What formula would I use to show Accept
for -2 to +2 in all of cells J4 thru L4 and Reject for any value exceeding -2
to +2 in any one of the cells J4 thru L4?

=IF(MAX(INDEX(ABS(J4:L4),0))<=2,"Accept","Reject")


"gfoster" wrote:

I am collecting data for a salt bath temperature comparison. There are three
readings from the salt bath (controller, high and low) and 3 readings from a
test sensor. The test sensor readings are subtracted from the bath readings
and the results are listed in cells J4, K4 and L4. I am allowed +/- 2
degrees difference for the test to be acceptable. In cell M4, I want the
results to show Accept or Reject. What formula would I use to show Accept
for -2 to +2 in all of cells J4 thru L4 and Reject for any value exceeding -2
to +2 in any one of the cells J4 thru L4?