excel function search

E

Ed Ferrero

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for non-consecutive text 3
WORD VBA Search and switch to advanced ... 1
IOS App: Contacts in search or in new mail not found 0
Excel - Wich Function should I use? 1
Word macro that can call cells out of Excel for a find and replace 0
Help creating a search form in Access XP 0
Need Help with Macro Security 1
Difficulty with compatibility mode and Track Changes 2

Top