ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How can if statement check multiple cells? (https://www.excelbanter.com/new-users-excel/448142-how-can-if-statement-check-multiple-cells.html)

 Jgomez February 7th 13 11:36 PM

How can if statement check multiple cells?

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.

 Spencer101 February 9th 13 12:22 AM

Quote:
 Originally Posted by Jgomez (Post 1609206) 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,""))

 All times are GMT +1. The time now is 09:17 AM.