excel function search
 

searching for function to give output if value "is between" limits

excel function search
 

Hi excel novice,

searching for function to give output if value "is between" limits

Use IF and AND like this;
=IF(AND(value=lowerLimit,value<=upperLimit),Answe rIfTrue,AnswerIfFalse)

eg.
This will output 100 if A1 is between 20 and 30, otherwise evaluates to zero
=IF(AND(A1=20,A1<=30),100,0)

This will output 100 if A1 is between B1 and C1, otherwise evaluates to zero
=IF(AND(A1=B1,A1<=C1),100,0)

Ed Ferrero
www.edferrero.com