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