using the random function

[aries]

I have made a 10 x 10 cell table with the formula =RAND()*100 in each cell.

When I copy and paste one cell onto itself or another within the table, all
of the results change within the whole table.

As a matter of fact, when I use the formula =RAND()*anything at all and
create other tables on the same worksheet, all of the results for all tables
on the whole worksheet change when one cell is copied and pasted.

I want to know why.

Thanks, anybody... ???

 

[Gary''s Student]

RAND() is volatile.

Whenever you make a change on the worksheet simple RAND() functions
re-calculate.