is number between values
 

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"