Try the randbetween function. i.e. =RANDBETWEEN(1,500). This will give you an integer between 1 and 500 each time.
