Results 1 to 7 of 7

Nested If Function Ignore False Values and Continue Evaluation + Concatenation

Threaded View

cullenju Nested If Function Ignore... 05-17-2018, 03:07 PM
Rev12 Re: Nested If Function Ignore... 05-17-2018, 03:18 PM
cullenju Re: Nested If Function Ignore... 05-17-2018, 03:26 PM
Rev12 Re: Nested If Function Ignore... 05-17-2018, 03:30 PM
cullenju Re: Nested If Function Ignore... 05-17-2018, 03:30 PM
Rev12 Re: Nested If Function Ignore... 05-17-2018, 05:05 PM
cullenju Re: Nested If Function Ignore... 05-18-2018, 11:52 AM
  1. #1
    Registered User
    Join Date
    05-17-2018
    Location
    Phoenix, AZ
    MS-Off Ver
    2016
    Posts
    4

    Nested If Function Ignore False Values and Continue Evaluation + Concatenation

    I'm trying to run a nested if function across a series of columns and concatenate the values where the criteria is true. I'm evaluating a series of flags each in a different column and if the flag is set to Y, I'm concatenating the label in a string for output. If the value is blank, I'm getting a FALSE value returned from the formula and the rest of the if statements aren't executed. Trying to do this without getting into code/macros. Any ideas?

    Data - Row 1 has the flag names (flag 1, flag 2, etc...). Row 2 has the indicators.

    Here is the formula - =IF(B2="Y",B1&" "&IF(C2="Y",C1&" "&IF(D2="Y",D1&" "&IF(E2="Y",E1&" "&IF(F2="Y",F1&" ","")))))

    Result when I set flag3 to blank or N

    Flag 1 Flag2 FALSE

    I have also tried the IFERROR function as well and get the same result. =IFERROR(IF(B2="Y",B1&" "&IF(C2="Y",C1&" "&IF(D2="Y",D1&" "&IF(E2="Y",E1&" "&IF(F2="Y",F1&" ",""))))),"")


    Please let me know if you have any ideas on how to bypass the false value and continue evaluating the if statements and combining the results.

    Thanks
    Last edited by cullenju; 05-18-2018 at 11:54 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] how to make nested if statement for multiple criteria and ignore false's
    By kevinu in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2017, 05:32 PM
  2. Nested If function returning FALSE instead of number
    By erimhast in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2015, 07:47 PM
  3. Replies: 10
    Last Post: 12-04-2013, 04:10 AM
  4. [SOLVED] If Function is False continue to check row below for true value
    By BearsBikes in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-26-2013, 10:02 PM
  5. SUMPRODUCT Evaluation for TRUE or FALSE for all the Meeting Criterions?
    By e4excel in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 01-06-2012, 08:01 PM
  6. True/False Function, ignore blank
    By cicihk in forum Excel General
    Replies: 2
    Last Post: 11-15-2010, 03:20 AM
  7. CONCATENATION evaluation problem?
    By Gunkie in forum Excel General
    Replies: 2
    Last Post: 02-26-2005, 11:06 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