The odds of arriving exactly at 1.00000000000000 were NOT 0.
Indeed they happen once in around several tens of thousands of times.
I made this checked by doing this...
1. I used a formula "=int(rand())"
2. I pasted it in area of "A1:T50000"
This means I tried 1,000,000 cells.
3. in cell U1 I made a formula "=MAX(A1:T50000)"
4. U1 says "1 " insted of "0". If Philip had been right, U1 should be "0".
5 Then I counted the cells which say 1.
6 There were 20-40 such cells. The number of such cells varies time to time.
I regret to say that You were wrong, Philip.
The odds of arriving exactly at 1.00000000000000 were NOT 0.
Indeed they happen once in around several tens of thousands of times.
I made this checked by doing this...
1. I used a formula "=int(rand())"
2. I pasted it in area of "A1:T50000"
This means I tried 1,000,000 cells.
3. in cell U1 I made a formula "=MAX(A1:T50000)"
4. U1 says "1 " insted of "0". If Philip had been right, U1 should be "0".
5 Then I counted the cells which say 1.
6 There were 20-40 such cells. The number of such cells varies time to time.
You should have tried it !!