is number between values
 

Thanks, that worked well, but, is there a way to get the numerical value of
measurments outside the range)
..005 too high

"bpeltzer" wrote:

If the dimension is in A1:
=if(a1<0.5943,"too low",if(a10.7129,"too high","just right"))

"chuckwagon2031" wrote:

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 .7129", the low limit is .5943"