Thank you for your help.

"bj" wrote:

> try
> =if(num < lower bound,num-lower bound,if(num>upperbound,num-upper
> bound,"within range")
>
> "Cat" wrote:
>
> > Help - I need to set up a formula that determines whether a number falls
> > within a certain range. If not, I need it to show how much under or over the
> > number is from the range.