+ Reply to Thread
Results 1 to 3 of 3

Complicated Query (At Least I think So)

  1. #1
    Registered User
    Join Date
    04-09-2008
    Location
    SA
    MS-Off Ver
    MS Office
    Posts
    2

    Question Complicated Query (At Least I think So)

    Hi Everyone

    I know it's my first post and i'm already asking for help but i can't seem to find the solution anywhere!?

    I'm tryin to calculate points based on cards

    There Are Two Colours Of Cards (Red And Yellow) (Column A)
    There Are 5 Types Of Cards (1;2;3;4;5) (Column B)
    Yellow Cards Give You 4 Points, regardless of the type
    RED however, 1 and 2 Give 10 points and 3;4;5 give you 12 points
    Points are in column C

    A3 Is Where I would put either R (Red) or Y (Yellow)
    B3 Is the type of card (Range from 1;2;3;4;5)
    C3 Is going to be the total.

    I managed to put this together........
    C3 is =IF(A3="Y",4,IF(A3="R",10))

    But as you can see i haven't managed to use the card type.
    I needed excel to add 2 points Only when a Red Card With a 3;4;5 Card Type Combination Arose
    Is what i'm trying to achieve even possible?
    Any help would be appreciated.

    I've attached a file with what i got working

    Thanks!!
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    I know it's my first post and i'm already asking for help ...
    That's what people tend to do here ...

    =IF(A3="Y", 4, CHOOSE(B3, 10, 10, 12, 12, 12))

  3. #3
    Registered User
    Join Date
    04-09-2008
    Location
    SA
    MS-Off Ver
    MS Office
    Posts
    2

    Thanks!!!!

    Thanks Alot, Worked like a charm!!!

+ 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