RAND() returns a random number >= 0 and <1

So the following returns a random integer between 0 and <50:

ROUND(RAND() * 50)

The following returns a random integer between 10 and <60:

ROUND((RAND() * 50) + 10 )
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *