Do you mean: there are 100 numbered squares and you buy a ticket with a
number?
Clearly the chances of winning are 1/100
If I buy four tickets, the odds for the first is 1/100, the odds for the
second is 1/100, etc.
So the odds with four tickets is 1//100 + 1/100 + 1/100 + 1/100 = 4/100 or
1/25

Suggestion: forget Excel and read a simple book on probability (statistics).
It is foolish to try to use Excel to solve problems that you do not
understand.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RichM" wrote in message
...
I have 100 squares. what are the odds if I buy 1 ticket. what are the odds
if
I buy 4 tickets.

How do I get excel to do this?