View Single Post
  #1   Report Post  
Old February 7th 13, 11:36 PM
Jgomez Jgomez is offline
Junior Member
First recorded activity by ExcelBanter: Feb 2013
Posts: 1
Default How can if statement check multiple cells?


I have this forumula that I need to expand but I'm lost.

I have =IF(Sheet1!AH21<"",Sheet1!AH52,"")

What I need is if AH21 = "" then it needs to go to cell AB21 & if that cell is not blank then it should equal AB52 but if AB21 is blank then it should check V21, if that cell is <"" then it should equal V52 if all blank then I should have a null value.