Making rand() update every iteration

[incblue]

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?

 

[incblue]

Bump
Can somebody try the following:
I would like to see what someone else's results are.

If you set up A1 to D1 like this, with these calculation settings, then I am sure you will see what I mean.

 

[shg]

I expect their results are the same as yours. I think the iterative recalculation only applies to cells with circular references, not all the cells in the workbook and not their precedents.

 

[ibobia]

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 replaced the simple formula =RAND() with =if(anycondition, RAND(),RAND()) . Excel will recalculate formula every iteration. Don't care the if condition.