| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Satisfying Multiple Criteria in an "IF" Function
I need a formula that looks to see that a value is greater than one cell and
less than or equal to another. If the results are valid, I want it to say "yes". If not valid, then result as blank. I have an IF formula that satifies one value but not for two. It looks like this: if(A1=B1,C1,"") How do I make it work to satisfy multiple criteria? Thanks -- JerryS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Satisfying Multiple Criteria in an "IF" Function
maybe this
=IF(AND(A1A2,A1<=A3),C1,"") Mike "Jerry B Smith" wrote: I need a formula that looks to see that a value is greater than one cell and less than or equal to another. If the results are valid, I want it to say "yes". If not valid, then result as blank. I have an IF formula that satifies one value but not for two. It looks like this: if(A1=B1,C1,"") How do I make it work to satisfy multiple criteria? Thanks -- JerryS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| If function with some "And" plus an "Or" criteria | Excel Discussion (Misc queries) | |||
| i have about 100 worksheets, how do i "lookup" multiple criteria | Excel Discussion (Misc queries) | |||
| Criteria governing "LARGE" function | Excel Discussion (Misc queries) | |||
| Sumproduct-multiple criteria for same range "OR" | Excel Worksheet Functions | |||
Linear Mode
