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. |
Quote:
|
All times are GMT +1. The time now is 01:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com