Lotto Trigger

[Steve 1962]

Hi

I am attempting to have winning lotto combination flag a "winner" notification in cell C17. Currently it operates OK for the lottery however, an extra winning combination has been introduced which renders my formula useless. Previously, a minimum of three "main numbers" (column "A") and a minimum of one "supplementary" (column "B") would trigger a "winner" in cell C17. Now, an additional two prizes have been introduced which trigger a "winner" but I can't get the formula to work. The new two combinations are in rows 13 & 14 (eg: 2 main + 2 supplementary or 1 main + 2 supplementary). Any suggestions as to how I can modify my current formula to accommodate the change.

Thanks

Steve

Excel Workbook
	A	B	C
1	Main Number	Supplementary
2	6	2
3	6	1
4	6	0
5	5	2
6	5	1
7	5	0
8	4	2
9	4	1
10	4	0
11	3	2
12	3	1
13	2	2
14	1	2
15
16
17	3	1	Winner
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C17	=IF(OR(A17>3,AND(A17>2,B17>0)),"Winner","")

 

[Steve 1962]

Hello

Back on deck now. I have just gone through my spreadsheet and found that the mistake was on my end. All is working great now. I just want to says thanks for your help - for both the accuracy and speed of your reply.

I can't express how important this site is to regular Excel users.

All the best and have a great week.

Steve

 

[T. Valko]

Hello

Back on deck now. I have just gone through my spreadsheet and found that the mistake was on my end. All is working great now. I just want to says thanks for your help - for both the accuracy and speed of your reply.

I can't express how important this site is to regular Excel users.

All the best and have a great week.

Steve

You're welcome. Thanks for the feedback!