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