| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula to determine whether number falls within 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. |
|
#2
|
|||
|
|||
|
=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" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
try
=if(num < lower bound,num-lower bound,if(numupperbound,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. |
|
#4
|
|||
|
|||
|
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" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
Thank you for your help.
"bj" wrote: try =if(num < lower bound,num-lower bound,if(numupperbound,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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to tell if cell contains a FORMULA or user-entered number? | Excel Worksheet Functions | |||
| Formula to determine shift | Excel Worksheet Functions | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| Need excel formula to sum 1+2+3...+N given a number N | Excel Worksheet Functions | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
Linear Mode
