using the random function

  • Thread starter Thread starter aries
  • Start date Start date
A

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... ???
 
RAND() is volatile.

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