If results for multiple cells

  • Thread starter Thread starter gfoster
  • Start date Start date
G

gfoster

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?
 
Back
Top