excel function search

[excel novice]

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

 

[Ed Ferrero]

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),AnswerIfTrue,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