+ Reply to Thread
Results 1 to 3 of 3

Ignore blank rows in an IF Statement

  1. #1
    Registered User
    Join Date
    07-02-2011
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    28

    Question Ignore blank rows in an IF Statement

    I have a nested IF statement, which runs through checking if there is text in specific cells and returning fail as soon as text is encountered in one of thel celle, otehrwise returning pass if not. Only thing is I have blank rows between each data row and I want to be able to drag the formula down, but have nothing populate where the row is blank. Due to my formula, this keeps returning a pass. The formula I am currently using is a standard if formula - as below:

    =IF($A12="CHECK","MANUAL",IF($M12<>"","FAIL",IF($J12<>"","FAIL",IF($F12<>"","FAIL",IF($D12<>"","FAIL","PASS")))))

    What do I need to add to this/change to add a condition to ignore the bank rows.

    Please see my attachment for further detail.

    Thanks
    Connie
    Attached Files Attached Files
    Last edited by connieb; 10-28-2019 at 09:42 PM.

  2. #2
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Ignore blank rows in an IF Statement

    Your formula doing this.
    Please Login or Register  to view this content.
    Same to : If any text was enter in M, J, F or D all are 'FAIL' others is 'PASS' (while A <> "CHECK")

    You can adjust your formula to avoid 'Blank' rows by check for A first.

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

    Regards.

  3. #3
    Registered User
    Join Date
    07-02-2011
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Ignore blank rows in an IF Statement

    That's perfect and a much tidier syntax. Thanks menem

+ 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] combine If statement and ignore blank cell
    By RINGLEADER in forum Excel General
    Replies: 3
    Last Post: 10-16-2018, 05:01 AM
  2. Ignore blank rows while printing
    By anilpatni1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2018, 07:17 AM
  3. Index Match Function? Ignore blank rows - (rows without values)
    By jgray in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2015, 01:12 PM
  4. Replies: 3
    Last Post: 04-15-2014, 03:59 PM
  5. [SOLVED] Ignore Blank cells in IF statement while matching columns
    By pareshvm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2014, 02:17 AM
  6. [SOLVED] How can I ignore blank rows in this VB
    By Ginge1267 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-14-2013, 07:21 AM
  7. If statement (Ignore blank)
    By lisadang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2008, 12:19 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