+ Reply to Thread
Results 1 to 3 of 3

Including two conditions in a nested IF if FALSE

  1. #1
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Including two conditions in a nested IF if FALSE

    Hi,

    I am working on a file (attached sample file) that has a calculated field using nested IF. The formula is written to satisfy multiple criteria to calculate the file.

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


    In a part of the formula that is mentioned above, I want to return C2 if AND(D2<C2,G2<>0,I2<>0,B2="Group B") are TRUE. If only B2="Group B" is FALSE, I want to return D2. But the issue I have here is that I want to add other criteria in this formula so that it checks for every criteria and returns the value accordingly. I am a little confused on how to approach this. If anybody can suggest a different approach to deal with this situation, it will be greatly appreciated.

    If the above explanation is not clear, in the attached file, I've highlighted the Criteria under "List of Criteria", that I've tried explaining above. The formula in column L is written based on all the criteria listed in the file.

    If further explanation is needed, please feel free to ask any questions.

    Thanks

    VJ
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Including two conditions in a nested IF if FALSE

    There is no grater then or equal in your nested IF() this can become a problem.

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

  3. #3
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Re: Including two conditions in a nested IF if FALSE

    Hi DJunqueira

    Thanks for the inputs. Much Appreciated.

    VJ

+ 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] Getting FALSE on nested ifs function
    By eirik.joansen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-21-2021, 07:36 PM
  2. Replies: 1
    Last Post: 03-02-2021, 10:50 PM
  3. IF with SUM can I add two [value if false] in nested IF?
    By SandroUK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-01-2020, 09:43 AM
  4. [SOLVED] NESTED IF returning false
    By VicAC in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-24-2019, 06:18 AM
  5. [SOLVED] Nested IF Statement goes to False
    By unit285 in forum Excel General
    Replies: 14
    Last Post: 11-14-2015, 01:29 PM
  6. [SOLVED] if(and(...... formula including another if for false
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-28-2013, 09:50 AM
  7. Excel 2007 : AVERAGEIFS including several conditions
    By milliemoo in forum Excel General
    Replies: 6
    Last Post: 11-16-2011, 11:39 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