Thread: How can if statement check multiple cells?
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Jgomez View Post
Hello!

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.
=IF(AND(AH21="",AB21<""),AB52,IF(AND(AH21="",AB21 =""),V21,""))
Reply With QuoteReply With Quote