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 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.

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