Determine if a cell value is within upper and lower bounds?

Try

=IF(ABS(Setpoint-Result)<=0.6,"OK","FAIL")

Originally Posted by Jonmo1

Try

=IF(ABS(Setpoint-Result)<=0.6,"OK","FAIL")

This also works just fine. Different way of thinking about the comparison. I like it.

Originally Posted by Special-K

=IF(AND(Result>=Setpoint-0.6,Result<=Setpoint+0.6), "OK", "FAIL")

This worked right away. I should have read up on the usage of AND in Excel. I just came from programming a lot of Python scripts, so that's where my mind was, haha.

Originally Posted by Ron Coderre

A1: test number....12
B1: setpoint.....20
C1: tolerance...5

This regular formula returns OK if the test number is within the tolerance of the setpoint...otherwise Fail:
D1: =IF(MEDIAN(A1,B1-C1,B1+C1)=A1,"OK","Fail")

In the above example, the formula returns: Fail...because 12 is not between 15 and 25, inclusive.
If you change A1 to 16, the formula returns: OK

Is that something you can work with?

I had not used the MEDIAN function before. It looks like something I could use as well. Thanks for the help.

Originally Posted by MarvinP

Hi Darksabre and welcome to the forum,

I think you need to use the syntax of

=If(AND(Setpoint - .6 <= Result , Setpoint + .6 >= Result),"ok","fail")

See http://spreadsheets.about.com/od/exc...080117_and.htm for some other examples.

Thanks for the welcome

Yes, you are right - as Special-K showed, that is indeed the Syntax for the AND. Thanks for the link also.

Glad to help, thanks for the feedback.