Results 1 to 13 of 13

Selecting Numbers based on Complex Criteria

Threaded View

Deks Selecting Numbers based on... 10-28-2010, 06:13 PM
Marcol Re: Help Newbie w/ formula! 10-28-2010, 06:41 PM
squiggler47 Re: Help Newbie w/ formula! 10-29-2010, 05:58 AM
Deks Re: Help Newbie w/ formula! 10-29-2010, 03:58 PM
squiggler47 Re: Selecting Numbers based... 10-29-2010, 04:07 PM
Deks Re: Selecting Numbers based... 10-29-2010, 06:00 PM
squiggler47 Re: Selecting Numbers based... 10-30-2010, 03:27 AM
DonkeyOte Re: Selecting Numbers based... 10-30-2010, 04:42 AM
Deks Re: Selecting Numbers based... 10-30-2010, 04:37 AM
squiggler47 Re: Selecting Numbers based... 10-30-2010, 05:19 AM
squiggler47 Re: Selecting Numbers based... 10-30-2010, 05:32 AM
  1. #1
    Registered User
    Join Date
    10-28-2010
    Location
    NY, NY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Selecting Numbers based on Complex Criteria

    Sorry for making such confusion. I'm a newbie and needs help to write the formula to arrive at the sum presented in C1. I only know the simplest form like C1 = sum(a1+b1)

    RULE #1
    If A1 = 0, 1, 7, or 8 and B1 = any number, then C1 = 0
    If A1 = 2 and B1 = any number, then C1 =1
    If A1 = 3 and B1 = 0, 1, or 2, then C1 = 2
    If A1 = 4 and B1 = 0, 1, or 2, then C1 = 3
    If A1 = 3 or 4 and B1 = 3, then C1 = 4

    RULE #2
    If A1 = 0, 1, 2, 7, or 8 and B1 = 0, 1, or 8, then C1 = 0
    If A1 = 0, 1, 2, 7, or 8 and B1 = 2 or 3, then C1 = 2
    If A1 = 3 or 4 and B1 = 0 or 1, then C1 = 2
    If A1 = 3 and B1 = 2 or 3 , then C1 = 3
    If A1 = 4 and B1 = 2 or 3, then C1 = 4

    Any number is 0, 1, 2, 3, 8 (no 4, 5, 6, or 7)

    Thanks in advance!
    Last edited by Deks; 10-29-2010 at 03:56 PM. Reason: original title did not meet requirements

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