+ Reply to Thread
Results 1 to 7 of 7

Multiple If Statements if Cells are Blank

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    12

    Multiple If Statements if Cells are Blank

    Hi,

    I'm needing to know how to pull in values in a cell depending if the cells they're looking at are blank or not. For example, my formula currently is:
    =if(C1="",B1,C1) which works but i need to know if cells C1 and B1 are both blank to pull in the contents of cell A1.

    Basically, I need it to pull in the latest information if that makes sense?

    Thanks,

    Slim
    Attached Files Attached Files
    Last edited by SlimPickens; 04-04-2017 at 12:22 PM.

  2. #2
    Registered User
    Join Date
    03-17-2017
    Location
    Hell
    MS-Off Ver
    2010
    Posts
    172

    Re: Multiple If Statements if Cells are Blank

    attach the file please to know what you are trying to do.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Multiple If Statements if Cells are Blank

    Try this:

    =CHOOSE(COUNT(A1:C1),A1,B1,C1)

    or for text entries:

    =CHOOSE(COUNTA(A1:C1),A1,B1,C1)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    11-03-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Multiple If Statements if Cells are Blank

    I've attached file

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Multiple If Statements if Cells are Blank

    Did you try my suggestion? The first one works in your sample file.

  6. #6
    Registered User
    Join Date
    11-03-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Multiple If Statements if Cells are Blank

    Nice! Thank you AliGW

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Multiple If Statements if Cells are Blank

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If Statements and blank cells
    By Nick2512 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2017, 11:35 AM
  2. IF Statements, Dates, %, and Blank Cells
    By Karenh119 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2015, 04:00 PM
  3. [SOLVED] COUNTIF and IF statements to count non-blank cells only
    By rowena229 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-25-2015, 01:57 PM
  4. Nested If statements. I wanted blank/empty cells to not show 0
    By fleetwood417 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 11:09 AM
  5. Multiple If Statements and a Blank
    By theperson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2013, 02:32 PM
  6. Help with multiple IF statements & IF cell = blank
    By zipper_018 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2011, 04:48 PM
  7. Replies: 0
    Last Post: 09-04-2009, 07:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1