| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple criteria IF statements?
Can you have an if statement with mulitple criteria?
For example IF columns A1:A22 contain "High" and columns B1:B22 contain "Low" then returns a value of 5? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple criteria IF statements?
=IF(A:A="High",IF(B:B="Low",5,""),"")
If this post helps click Yes --------------- Jacob Skaria "Eán" wrote: Can you have an if statement with mulitple criteria? For example IF columns A1:A22 contain "High" and columns B1:B22 contain "Low" then returns a value of 5? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple criteria IF statements?
Per row?
=IF(AND(A1="High",B1="Low"),5,"") -- __________________________________ HTH Bob "Eán" wrote in message ... Can you have an if statement with mulitple criteria? For example IF columns A1:A22 contain "High" and columns B1:B22 contain "Low" then returns a value of 5? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selectively replace cells based on two ranges of criteria - nestedIF() statements? | Excel Discussion (Misc queries) | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
![Eán[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
