ExcelBanter - Multiple criteria IF statements?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple criteria IF statements? (https://www.excelbanter.com/excel-worksheet-functions/227175-multiple-criteria-if-statements.html)

EÃ¡n[_2_]

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?

Jacob Skaria

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?

Bob Phillips[_3_]

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?

All times are GMT +1. The time now is 01:25 PM.