H

#### Harry

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