Re: Random number generator

Posted by Nelson on February 14, 19103 at 16:01:53:

In Reply to: Random number generator posted by BeckyR on January 11, 2002 at 16:55:47:

: I want to generate random numbers but I need to set the range to start at 1000000000 instead of 0. Is there a way the starting number can be set?

RND function
A is number generated between 0 and 1
Ex. .896743 , .773420
C = RND(A*100000000)+1 , will give number like
34678995 , ie. number between 1000000000 n 999999999 . make test before if good.