Help with my Lotto code please

[Harry]

Would some kind person please make this formula work for me, it’s for a
lottery numbers checker I’m making, all works great but for this last bit.
I’ve tried many different ways without luck. I’ve left it this way as it best
shows what I want it to do. I’m sure it is probably an easy formula for those
who do these things but I’m just playing with it and learning. I’m 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"))))))

 

[Stefan B Rusynko]

Suggest you ask in an Excel Newsgroup
- this is a FrontPage newsgroup

--




| Would some kind person please make this formula work for me, it's for a
| lottery numbers checker I'm making, all works great but for this last bit.
| I've tried many different ways without luck. I've left it this way as it best
| shows what I want it to do. I'm sure it is probably an easy formula for those
| who do these things but I'm just playing with it and learning. I'm 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"))))))
|

 

[Richard]

Not really an Excel expert, but it looks like your last "IF" statement only
has two arguments and should have a third one right after "JACKPOT"

 

[Kathy]

Would some kind person please make this formula work for me, it's for a
lottery numbers checker I'm making, all works great but for this last bit.
I've tried many different ways without luck. I've left it this way as it best
shows what I want it to do. I'm sure it is probably an easy formula for those
who do these things but I'm just playing with it and learning. I'm 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"))))))

It will never work. As soon you get a match in S9, it'll display that
result. So if you have 5 in S9, it won't check W9 to see if there is a 1 in
there. If you have 6 in S9 and nothing in W9, it will show Big money as 6 +
blank =6. If you reverse the last two, it'll show Jackpot for 6, but it'll
never look at W9. You'd need to use an AND (or you could do it another way
with OR) with each IF to check W9 as well - then you'd run over the max no
of chars in a formula.
Try the excel vba programming newsgroup for a vba solution.

HTH

Kathy