Multiple criteria IF statements?

[Eán]

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]

=IF(A:A="High",IF(B:B="Low",5,""),"")

If this post helps click Yes

 

[Bob Phillips]

Per row?

=IF(AND(A1="High",B1="Low"),5,"")