Complicated Query (At Least I think So)

**Lil-Diabo** · 04-09-2008, 06:43 PM

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!!