I do not have a spreadsheet as an example.
I will create a new one to illustrate my problem if my explanation is confusing.
When using maximum iteration of 1, the rand() function clearly generates a new value every time you press F9.
However sometimes when I use a maximum iteration of 100, 1,000 or 10,000 it is clear that Excel has just generated one random value, and used this value for all 10,000 calculations instead of generating a new value every time.
Is there a way to force Excel to generate a new value every iteration?
I will create a new one to illustrate my problem if my explanation is confusing.
When using maximum iteration of 1, the rand() function clearly generates a new value every time you press F9.
However sometimes when I use a maximum iteration of 100, 1,000 or 10,000 it is clear that Excel has just generated one random value, and used this value for all 10,000 calculations instead of generating a new value every time.
Is there a way to force Excel to generate a new value every iteration?