Formula to determine whether number falls within range??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
try
=if(num < lower bound,num-lower bound,if(num>upperbound,num-upper
bound,"within range")
 
Ian, thank you.

Ian said:
=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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - count if a number falls within an array in a column & add 3
Sumif and Specified Ranges 2
Adding dates in columns 2
SUMIF data that falls within a range 3
If Formula Help 4
Finding quantity that falls within a range or Tier 3
counting colored data 9
If statement based on time ranges 2

Back
Top