View Single Post
  #2   Report Post  
Old February 9th 13, 12:22 AM
Spencer101 Spencer101 is offline
Senior Member
First recorded activity by ExcelBanter: Mar 2012
Posts: 663

Originally Posted by Jgomez View Post

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,""))