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"))))))