Thread: Multiple criteria IF statements?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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?
Reply With QuoteReply With Quote