Posted: Sat Jun 02, 2007 7:55 am Post subject: Rand() and Data Tables
There appears to be a problem with how the Rand() function works in conjunction with data tables (multiple.operations).
If the formula used for the data table involves a random number directly (such as NORMINV(RAND(),10,2)) then the data table will be populated with random numbers. If however, the formula used for the data table is a function of other cells involving random numbers (such as "=(C4+C5)/2" where C4 and C5 are each randomly generated numbers using NORMINV(RAND(),10,2) then the data table will NOT be populated with randomized numbers, but rather only 1 number.
The program should recalculate the entire sheet (including formulas of random numbers) for each row of a data table.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum