So I'm trying to use the RANDBETWEEN function in excel. I'm using it for DnD and want it to give me a random number between 1 and 20 and then add the base initiative of the monster, and display the result. This works. The problem is every time I change anything on the spreadsheet, such as calculating damage, it will recalculate the random number. Is there a way to have it autocalc once, and then stop running?
Use relativity rather then absolute calculation
Sgt. D. Pilla;4803430Use relativity rather then absolute calculation
It is using relative calculation already. The problem is that since it is a random number generator it re-calculates the random number every time the spreadsheet as a whole is calculated. I just need the cell that contains the random number generator to only calculate once, and then stop.
I'd say use a macro which would run only when you click a button or something like that.
I just started using excel for this project, so I know almost nothing, I'm just figuring things out as I go. Any idea how I might make such a macro, or if I could download one or something? If all else fails I"ll run the generator, and manually input the values into the cells.