Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix Calculation Help | Excel Discussion (Misc queries) | |||
How to perform matrix calculation in excel? | Excel Discussion (Misc queries) | |||
calculation of Determinant of a matrix | Excel Worksheet Functions | |||
calculating matrix values | Excel Worksheet Functions | |||
Matrix calculation | Excel Discussion (Misc queries) |