Formula to determine whether number falls within range??

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.

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.