+ Reply to Thread
Results 1 to 5 of 5

Nested IF Statement Referencing Multiple Cells

  1. #1
    Registered User
    Join Date
    03-08-2018
    Location
    Nashville, TN
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Nested IF Statement Referencing Multiple Cells

    Hello, I am trying to use a nested IF statement that references multiple cells. If a certain cell says YES, then I want the $ value in a specific cell. But if that cell is blank then I want the $ value in the cell above. Here is the formula I'm using: =IF(E33="YES",D39,IF(D39="",D38)). When cell D39 is blank i get 0.00, not the value in cell D38. Thanks in advance for your help!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,632

    Re: Nested IF Statement Referencing Multiple Cells

    What is in E33?

    If "YES", you get value in D39

    maybe this ...


    =IF(E33="YES",IF(D39="",D38,D39))

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Nested IF Statement Referencing Multiple Cells

    Hi

    What is the value required when E33 not YES or not blank.

    Cheers

  4. #4
    Registered User
    Join Date
    03-08-2018
    Location
    Nashville, TN
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Re: Nested IF Statement Referencing Multiple Cells

    Sorry for not stating so earlier.

    Cell E33 defaults to "Select an item" and has a dropdown with YES or NO. If NO is chosen then the cell where the formula is placed will show 0.00.

    JohnTopley, Your suggestion worked! Thanks so much for your help!

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,632

    Re: Nested IF Statement Referencing Multiple Cells

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Multiple IF Statement - nested IF, Sumproduct...
    By 1Stacy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2016, 12:37 PM
  2. Multiple if Nested Statement
    By slohman in forum Excel General
    Replies: 3
    Last Post: 07-18-2016, 07:53 PM
  3. Nested IF statement error. Nested True statement is not triggering
    By Lucas7040 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2016, 11:41 AM
  4. [SOLVED] if statement referencing a nested if(mid) statement
    By kantjustice in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2016, 06:27 PM
  5. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  6. [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
  7. Nested IF statement comparing value1 against multiple cells?
    By MJSlattery in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2012, 06:12 PM

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