Thread: Random Numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Soccer boy[_2_] Soccer boy[_2_] is offline
external usenet poster
 
Posts: 16
Default Random Numbers

i am trying to run a precipitation model and am using the Rand() function to
help generate numbers inbetween certain values. I am also using solver in my
spreadsheets, The solver is having a hard time calculating everything
because the random numbers are being regenerated every time. Without Copy
and Special Pasteing the Value of the generated random number, is there
another way i can keep the Rand() function from generating new numbers
everytime and only when i tell it too.