View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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"