+ Reply to Thread
Results 1 to 4 of 4

How to write this 4 condition nested formula?

  1. #1
    Registered User
    Join Date
    12-07-2005
    Posts
    4

    Question How to write this 4 condition nested formula?

    I'm trying to figure out how to write a formula to satisfy the following multiple conditions:

    If cell v4>1 and cell x4="FR",-1 and
    If cell v4=1 and cell x4="FR",3 and
    If cell v4>1 and cell x4="CL",2 and
    If cell v4=1 and cell x4="CL",-3

    So I have 2 cells I'm working with here and 4 conditions that I want to assign: either a -1,3,2, or -3, depending on whether the user types the text FR or CL into cell X4.

    Thanks and happy holidays.
    Frank

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    This should work for you...

    =IF(AND(V4>1,X4="FR"),-1,IF(AND(V4=1,X4="FR"),3,IF(AND(V4>1,X4="CL"),2,IF(AND(V4=1,X4="CL"),-3,"N/A"))))

    Returns "N/A" if none of the conditions are met, change to "" if you do not want this to happen.

    Good Luck

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Registered User
    Join Date
    12-07-2005
    Posts
    4
    Worked like a charm Bruce. A million thanks!
    It's kind of frustrating when you know what to do but not how to go about doing it.
    It makes me appreciate what a programmer must go through sometimes.

    Best regards,
    Frank

  4. #4
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    I'm glad it worked for you. Thanks for the feedback, it is always appreciated.

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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