+ Reply to Thread
Results 1 to 3 of 3

Checking for multiple blanks instead of one

  1. #1
    Registered User
    Join Date
    06-24-2019
    Location
    Sweden
    MS-Off Ver
    Office 16
    Posts
    49

    Checking for multiple blanks instead of one

    Hello!

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    What I wanna do is check for blanks between C15:F15 instead of just one cell (C15). If any of those 4 cells are blank, I want the formula to return blank.

    I'm unsure how it should look like. Any help appreciated!

    Best Regards!
    Last edited by wizzan1; 06-01-2020 at 10:06 PM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Checking for multiple blanks instead of one

    Not sure if C15:F15 is emty itself or there is formula that returns blank (i.e, =""), this formula works for both cases:

    Please Login or Register  to view this content.
    Quang PT

  3. #3
    Registered User
    Join Date
    06-24-2019
    Location
    Sweden
    MS-Off Ver
    Office 16
    Posts
    49

    Re: Checking for multiple blanks instead of one

    Wow, it worked like a charm! Thanks alot!

+ 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. Replies: 2
    Last Post: 04-22-2020, 11:41 AM
  2. BLANKS (Not Really Blanks) AND Rearrange ignoring blanks
    By shivspatil in forum Excel General
    Replies: 4
    Last Post: 02-02-2018, 08:28 AM
  3. Replies: 1
    Last Post: 07-05-2016, 06:35 AM
  4. Return non blanks from multiple columns in multiple sheets
    By msj12345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2015, 02:31 AM
  5. Checking multiple criteria and select data over multiple columns
    By jy677 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 09:38 PM
  6. Checking Multiple Values Against Multiple Columns
    By Maglor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2009, 08:40 PM
  7. Checking for a zero value in multiple columns
    By johnsoned in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2005, 08:30 PM

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