How can if statement check multiple cells?

J

Jgomez

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 tha
cell is not blank then it should equal AB52 but if AB21 is blank then i
should check V21, if that cell is <>"" then it should equal V52 if al
blank then I should have a null value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Dealing with the error: unable to filter on excel hc home school 0
Word macro that can call cells out of Excel for a find and replace 0
Mail Merge Help 1
Excel does not accept text format! 0
IF Statement - Correct Function? 6
Multiple IF Statement 2
Changing language for spell check not working? 1

Top