If results for multiple cells

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top