+ Reply to Thread
Results 1 to 3 of 3

Nested If with blank cells not working

  1. #1
    Registered User
    Join Date
    07-15-2019
    Location
    Miami, FL
    MS-Off Ver
    2019
    Posts
    6

    Angry Nested If with blank cells not working

    If there is no value in the first column N2 I need to calculate the value in M2, if there is no value there I need to calculate based on my L2. e.g.

    Current formula:

    =IF(N2="",M2-G2,IF(M2="",L2-G2,G2-G2))

    Capture.GIF
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Nested If with blank cells not working

    Hello Travis83. Welcome to the forum.

    Try


    A
    B
    C
    D
    E
    F
    1
    expected arrival
    Date 1
    Date 3
    Date 2
    Deviation (Neg=early)
    2
    7/9/2019
    7/1/2019
    7/12/2019
    11
    In E2: =LOOKUP(1E+306,A2:D2)-INDEX(A2:D2,MATCH(1E+306,A2:D2,1)-1)
    3
    7/9/2019
    7/1/2019
    7/2/2019
    7/2/2019
    0
    4
    7/4/2019
    6/20/2019
    -14
    5
    7/4/2019
    6/18/2019
    6/26/2019
    6/26/2019
    0
    Dave

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Nested If with blank cells not working

    Or, you could try it this way in E2:

    =IF(D2="",IF(C2="",IF(B2="",A2-A2,B2-A2),C2-A2),D2-A2)

    then copy down.

    Hope this helps.

    Pete

+ 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] Nested IF Statements with Blank Cells
    By 8krungirl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2018, 03:43 PM
  2. [SOLVED] Nested IF formula that ignores blank cells
    By si.mon in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-22-2018, 06:19 AM
  3. Nested IF to check blank cells
    By Mat87 in forum Excel General
    Replies: 5
    Last Post: 10-03-2016, 03:35 AM
  4. [SOLVED] Nested If statement, checking multiple cells for Blank cells
    By JLeague in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-30-2015, 11:18 AM
  5. [SOLVED] Nested IF`s and Blank cells
    By colaps in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2015, 10:11 AM
  6. 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
  7. Nested IF checking non blank cells
    By brentandrews in forum Excel General
    Replies: 2
    Last Post: 12-21-2009, 10:18 AM

Tags for this Thread

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