Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

If results for multiple cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gfoster - 07 May 2008 14:43 GMT
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?
Teethless mama - 07 May 2008 15:08 GMT
=IF(MAX(INDEX(ABS(J4:L4),0))<=2,"Accept","Reject")

> 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
[quoted text clipped - 4 lines]
> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.