Originally Posted by
Mousiefuzz
Cell A2 always stays the same, 100.
Cell B2 needs to increase by the amount in C2.
Cell C2 is a random number between 1 and 20.
[....]
I want the Value in B2 to increase with each refresh, rather than replace. Anyone have any ideas?
Click on File, Options, Formulas, checkmark Enable Iterative Calculation, and enter 1 into Maximum Iterations. Then enter the following formula into B2:
=IF(B2=0,A2,B2)+C2
where C2 contains =RANDBETWEEN(1,20).
Each time you press F9 (or edit any cell!), B2 will be increased by a new value in C2.
To restart, select B2, press F2, then Enter.
Personally, I abhor designs that rely on circular references. And I usually do not want RAND and RANDBETWEEN formulas directly in Excel because they change whenever Excel calculates anything (else).
IMHO, it is better to design a macro to perform the update. You can create a "button" to execute the macro whenever you want, as opposed to when Excel does. Or simple press alt+F8, select the macro name, and click on Run.
For example:
Bookmarks