ExcelBanter

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 10: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 8th 13 11:22 PM

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 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com