E Ed Ferrero Feb 1, 2010 #2 Hi excel novice, searching for function to give output if value "is between" limits Click to expand... 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
Hi excel novice, searching for function to give output if value "is between" limits Click to expand... 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
