how do I prevent a RAND number from changing

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Back
Top