RANDBETWEEN in Excel 4 replies

Please wait...

Guest

I didn't make it!

0 XP

 
#1 10 years ago

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?




Sgt. D. Pilla

Uber Geek

50 XP

23rd October 2007

0 Uploads

3,473 Posts

0 Threads

#2 10 years ago

Use relativity rather then absolute calculation




Guest

I didn't make it!

0 XP

 
#3 10 years ago
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.




ConstanceJill

Huh yeah, whatever ^^

38,777 XP

6th December 2006

0 Uploads

3,246 Posts

1 Threads

#4 10 years ago

I'd say use a macro which would run only when you click a button or something like that.




Guest

I didn't make it!

0 XP

 
#5 10 years ago

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.