Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Harry,

Try this

=IF(S9=3,"£10",IF(S9=4,"About £50",IF(S9+W9=6,"Big Money",IF(S9=5,"About
£500",IF(S9=6,"Jackpot","No Good")))))

Mike

"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Thanks for getting back to me Mike, I tried your formula but it does the same
as mine did. It doesnt show Jackpot with 6 Balls. Any ideas?
Thanks
Harry.

1 Ball = No Good S9
2 Balls = No Good S9
3 Balls = £10 S9
4 Balls = About £50 S9
5 Balls = About £500 S9
5 Balls and Bonus Ball = Big Money S9 + W9
6 Balls = Jackpot S9
Its the bonus ball that causes the problem as it involves two 5 Balls and a
total of 6 twice.


"Mike H" wrote:

Harry,

Try this

=IF(S9=3,"£10",IF(S9=4,"About £50",IF(S9+W9=6,"Big Money",IF(S9=5,"About
£500",IF(S9=6,"Jackpot","No Good")))))

Mike

"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Thanks p45cal,

Hope below explains things a bit better. Appreciate your help. I dont do
much of this but Im finding it fun.

Thanks,
Harry.
Code:
--------------------
Winning nos. | Bonus Ball | RESULT
1 0 no good
1 1 no good
2 0 no good
2 1 no good
3 0 £10
3 1 £10
4 0 About £50
4 1 About £50
5 0 About £500
5 1 Big money
6 0 jackpot


"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Hi again Mike,
Tried your code again, it almost works, I found it has to have 6 balls and
the Bonus ball to return €œJackpot€�. The lottery here in the UK only has 6
numbers so 6 balls and the Bonus ball never occurs. Only five balls brings
the bonus ball into play.
Harry.


"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Harry,

I see my error, try this

=IF(S9=3,"£10",IF(S9=4,"About £50",IF(AND(W90,S9+W9=6),"Big
Money",IF(S9=5,"About £500",IF(S9=6,"Jackpot","No Good")))))

Mike

"Harry" wrote:

Thanks for getting back to me Mike, I tried your formula but it does the same
as mine did. It doesnt show Jackpot with 6 Balls. Any ideas?
Thanks
Harry.

1 Ball = No Good S9
2 Balls = No Good S9
3 Balls = £10 S9
4 Balls = About £50 S9
5 Balls = About £500 S9
5 Balls and Bonus Ball = Big Money S9 + W9
6 Balls = Jackpot S9
Its the bonus ball that causes the problem as it involves two 5 Balls and a
total of 6 twice.


"Mike H" wrote:

Harry,

Try this

=IF(S9=3,"£10",IF(S9=4,"About £50",IF(S9+W9=6,"Big Money",IF(S9=5,"About
£500",IF(S9=6,"Jackpot","No Good")))))

Mike

"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Hi Mike,
That works great. A bit more complicated than I thought and beyond my
capabilities.
I dont suppose €œJackpot€� will ever pop up, who knows?
Thanks very much for your help.
Regards,
Harry.


"Mike H" wrote:

Harry,

I see my error, try this

=IF(S9=3,"£10",IF(S9=4,"About £50",IF(AND(W90,S9+W9=6),"Big
Money",IF(S9=5,"About £500",IF(S9=6,"Jackpot","No Good")))))

Mike

"Harry" wrote:

Thanks for getting back to me Mike, I tried your formula but it does the same
as mine did. It doesnt show Jackpot with 6 Balls. Any ideas?
Thanks
Harry.

1 Ball = No Good S9
2 Balls = No Good S9
3 Balls = £10 S9
4 Balls = About £50 S9
5 Balls = About £500 S9
5 Balls and Bonus Ball = Big Money S9 + W9
6 Balls = Jackpot S9
Its the bonus ball that causes the problem as it involves two 5 Balls and a
total of 6 twice.


"Mike H" wrote:

Harry,

Try this

=IF(S9=3,"£10",IF(S9=4,"About £50",IF(S9+W9=6,"Big Money",IF(S9=5,"About
£500",IF(S9=6,"Jackpot","No Good")))))

Mike

"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Hi,

Suppose you set up the following lookup table:
0 No Luck
3 £10.00
4 About £50.00
5 About £500.00
5.5 Big Money
6 Jackpot

Then you could use a simple formula like:

=VLOOKUP(W9/2+S9,A1:B6,2)

where the table is in the range A1:B6.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))

Thank's Shane, I'll give it a try.

Harry.

"Shane Devenshire" wrote:

Hi,

Suppose you set up the following lookup table:
0 No Luck
3 £10.00
4 About £50.00
5 About £500.00
5.5 Big Money
6 Jackpot

Then you could use a simple formula like:

=VLOOKUP(W9/2+S9,A1:B6,2)

where the table is in the range A1:B6.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Harry" wrote:

Would some kind person please make this formula work for me, its for a
lottery numbers checker Im making, all works great but for this last bit.
Ive tried many different ways without luck. Ive left it this way as it best
shows what I want it to do. Im sure it is probably an easy formula for those
who do these things but Im just playing with it and learning. Im using
Excel 2007.
We do 20 tickets 2 times a week always with the same numbers so the checker
just needs the winning numbers entered to give the results.
Thank you in advance for any help.
Harry.
Cell S9 is the number of winning numbers between 1-6 and cell W9 is the
bonus ball 0 or 1.
=IF(S9<3,"NO GOOD",IF(S9=3,"£10",IF(S9=4,"ABOUT £50",IF(S9=5,"ABOUT
£500",IF(S9+W9=6,"BIG MONEY",IF(S9=6,"JACKPOT"))))))