Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check for text in multiple cells | Excel Discussion (Misc queries) | |||
Check multiple cells for a match | Excel Discussion (Misc queries) | |||
link check boxes in multiple cells | Excel Discussion (Misc queries) | |||
How to check multiple cells | Excel Worksheet Functions | |||
Reference multiple cells in if statement | Excel Worksheet Functions |