Remember Me?

#1
February 7th 13, 11:36 PM
 Junior Member First recorded activity by ExcelBanter: Feb 2013 Posts: 1
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.

#2
February 9th 13, 12:22 AM
 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 663

Quote:
 Originally Posted by 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 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,""))

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post tommcbrny Excel Discussion (Misc queries) 4 November 12th 09 04:10 PM Rusty Excel Discussion (Misc queries) 4 May 15th 09 06:57 AM Taz22i Excel Discussion (Misc queries) 1 July 17th 08 04:24 PM Sharon Mann Excel Worksheet Functions 3 January 22nd 06 03:35 PM PAR Excel Worksheet Functions 1 June 10th 05 06:28 AM

All times are GMT +1. The time now is 12:13 AM.