how do I prevent a RAND number from changing

G

Guest

Using RAND or RANDBETWEEN to randomly select a number from a specific range
allows a new random number to be calculated when any other cell is filled
and tabbed. I only want the random number to change when F9 is used. How can
this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Randbetween Range Problem 0
generate a random number and use if function to generate new data 4
How can I use the same random number twice in the same formula? 2
Defaulting a random number 3
How can I use the result from ADDRESS in another formula 8
How do you avoid duplicates when using the randbetween function? 2
Stop automatically changing value in =RAND or =RANDBETWEEN 10
Using "=randbetween" to select a number from a range of cells 4

Top