Results 1 to 2 of 2

Simplify and Combine Complicated Conditional Formula

Threaded View

  1. #1
    Forum Contributor amyxkatexx's Avatar
    Join Date
    11-23-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    128

    Simplify and Combine Complicated Conditional Formula

    I would like to both combine these 3 if statements so that it can be placed into one cell.

    =IF((AND(A2<>"",C2="Variation Parent")),A2,"")

    OR

    =IF((AND(A2<>"",C2="Variation Child")),A2,"")

    OR

    =IF((AND(C2<>"",C2<>"RelationType",C2<>"Variation Parent",C2<>"Variation Child")),B1,"")

    I would also like to simplify any unnecessary repetition within these statements.

    I know that the first two lines should be able to be simplified because they both return the same true and false values, but I'm not sure how to do that.

    I also know that the third line is just a bunch of things that are not equal to C2, so isn't there a way to simplify all of those?

    I don't know much else that can be done to simplify it though, but if anyone knows anything else, please let me know and if possible, show me how.

    Just to clarify though, simplification is not the main priority here; combining these 3 lines into one working statement is what I really need.

    Thanks in advance.
    Last edited by amyxkatexx; 04-14-2010 at 02:12 PM.

Thread Information

Users Browsing this Thread

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

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