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.
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.
=IF(AND(A1>=A2,A1<+A3),"Within Range",IF(A1<A2,A2-A1&" below range",A1-A3&"
above range"))
A1 is your number A2 & A3 are lower and upper limits of the range.
--
Ian
--
"Cat" <Cat@discussions.microsoft.com> wrote in message
news:E5E8131B-4C3A-4429-BF76-AB8DD7ADE3DC@microsoft.com...
> 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.
Ian, thank you.
"Ian" wrote:
> =IF(AND(A1>=A2,A1<+A3),"Within Range",IF(A1<A2,A2-A1&" below range",A1-A3&"
> above range"))
>
> A1 is your number A2 & A3 are lower and upper limits of the range.
>
> --
> Ian
> --
> "Cat" <Cat@discussions.microsoft.com> wrote in message
> news:E5E8131B-4C3A-4429-BF76-AB8DD7ADE3DC@microsoft.com...
> > 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.
>
>
>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks