Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel function search
searching for function to give output if value "is between" limits
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Search Function | Excel Discussion (Misc queries) | |||
Excel search function | Excel Discussion (Misc queries) | |||
Search function keeps quitting in Excel | Excel Worksheet Functions | |||
Excel search function | Excel Discussion (Misc queries) | |||
Excel Search function | Excel Discussion (Misc queries) |