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.
|