Results 1 to 5 of 5

Need Help with Multiple Condition Nested Logical Functions

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2010
    Posts
    48

    Need Help with Multiple Condition Nested Logical Functions

    I am having trouble evaluating two conditions with nested logical operators to produce the output I need.

    For example Condition 1 has 5 choices (A,B,C,D,E) and Condition 2 has 3 choices (a,b,c).

    Breaking it down,
    [Condition 1] option "A" always applies and should give "Yes" (No matter [condition 2], "A" always gives "Yes")
    [Condition 2] option "c" always applies and should give "Yes" (No matter [condition 1], "c" always gives "Yes")

    [Condition 1] option "D" never applies and should give "No" (No matter [condition 2], "D" always gives "No")

    [Condition 1] options "C" and "B" only apply if [condition 2] is "b" (if so, the answer is "Yes")


    What I need is the equivalent of:

    if ((([condition 1] == A) || ([Condition 2] == c)) || (([condition 1] == B || C) && ([condition 2] == b)), "Yes", "No")
    Last edited by SandPounder1; 02-17-2014 at 05:24 PM. Reason: fixed a typo

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to give multiple logical condition in one cell
    By ganeshadeshpande in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-03-2013, 08:42 AM
  2. Multiple logical functions resulting in multiple outcomes
    By PaddyG in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2012, 12:20 PM
  3. [SOLVED] Nested IFS and multiple logical formulae
    By jdohlinger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2012, 01:41 PM
  4. LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
    By luiss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2005, 12:08 PM
  5. [SOLVED] how do I use multiple nested functions?
    By TeeJay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2005, 02:06 PM

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