software

I am measuring a selection of cast metal parts. What formula do I use to
determine whether the dimension is highrer than the upper limit or lower than
the lower limit.
The high limit is .7129quot;, the low limit is .5943quot;


Presuming value to work with is in A1, use this formula:

=IF(A1gt;0.7129,quot;HIGHquot;,IF(A1lt;0.5943,quot;LOWquot;,A1))--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: www.excelforum.com/member.php...oamp;userid=28611
View this thread: www.excelforum.com/showthread...hreadid=526569Lotus123 wrote...
gt;Presuming value to work with is in A1, use this formula:
gt;
gt;=IF(A1gt;0.7129,quot;HIGHquot;,IF(A1lt;0.5943,quot;LOWquot;,A1))
....

More condensed than the other responses, but why not use a table
lookup?

=LOOKUP(A1,{0;0.5943;0.7129},{quot;LOWquot;;quot;OKquot;;quot;HIGHquot;})

Note that in the wonderful world of Excel, if A1 contained text or
boolean (TRUE/FALSE) values, the IF formula would invariably return
HIGH since text and both boolean values are treated as greater than any
number value, but the LOOKUP formula returns #N/A when A1 is text or
boolean.