Average should alway be close to 5.5, that is (10 + 1) / 2.
The more you do the closer you get.
So, you are doing something wrong to get 6.11 or similar.
Are you not doing CLng (in VBA) instead of Int?
Due to the rounding that would give you your average figures.

RBS


"The Dude" <f_com2°AT°yahoo°DOT°fr wrote in message
...
Hello :)

I am using a random number generation with a Randomize statement at the
beginning of the procedure.
My formula is Int ( 10 * Rnd + 1 ) to get a number between 1 and 10.

Thing is I have been trying this formula on 30 * 65536 cells and for each
session I get a 6.11 average. Most of the time it changes after the third
figure (like 6.114 instead of 6.112) but I am very surprised by the
similarity of the results...

Is that supposed to happen or am I doing something wrong?

Thanks
T_D