Thread: Multiple criteria IF statements?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default 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 With QuoteReply With Quote