Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
akile002
Contributor
Contributor

Does the rand function throw out previous samples or put them back?

I have a user that is using =rand()<0.10+0*now() to pull a sample. A bookmark was created and turned into a button to select the sample. What we are wanting to know is that if the button is clicked more than once, does the previous sample get thrown out or does it throw all selections back in and select another random sample?

1 Reply
swuehl
MVP
MVP

I am not sure if I understood what you are asking but as far as I know, RAND() will not throw out previous samples, so there is a likelyhood to get the same value twice returned from RAND().