using the random function

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... ???

RAND() is volatile.

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

--
Gary''s Student - gsnu200906


"aries" wrote:

> 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... ???