Calculating and re-calculation a matrix of 100 numbers in Excel
 

I am using Excel to calculate a matrix of 100 random numbers and sum the total
place the result in a cell, generate new random numbers for the matrix and sum
those place the result in a second cell, and so on.

I am using a Do while loop however -how do I get each calculation of the sum in
a cell to be independent from previous calculations in other cells? Right now
my program just recalculates the matrix and I get the same answer for each
cell.

Thanks,

SA

Calculating and re-calculation a matrix of 100 numbers in Excel
 

What formulas do you use? Both for the matrix and the sum?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"SAND1100" wrote in message
...

I am using Excel to calculate a matrix of 100 random numbers and sum the
total
place the result in a cell, generate new random numbers for the matrix and
sum
those place the result in a second cell, and so on.

I am using a Do while loop however -how do I get each calculation of the
sum in
a cell to be independent from previous calculations in other cells? Right
now
my program just recalculates the matrix and I get the same answer for each
cell.

Thanks,

SA