Generate Random Numbers

ts22

How would I assign a random number using rand or another function if I want the range to be between 0 to 16?

Datasets

Developer Tools

Accepted answers

AndrewBanh

Hi @ts22

Try the formula:

rand() * 16

The expression rand() generates a number between 0 - 1 so just multiply by 16, and set the data type as Int32 or something, so that there are no decimals.

If you want Double to be your Data type, then use something like ceil(rand() * 16) instead.

Hope that helps.

- Andrew

All comments

AndrewBanh

Hi @ts22

Try the formula:

rand() * 16

The expression rand() generates a number between 0 - 1 so just multiply by 16, and set the data type as Int32 or something, so that there are no decimals.

If you want Double to be your Data type, then use something like ceil(rand() * 16) instead.

Hope that helps.

- Andrew

ts22

Thank you, I appreciate it!

MarqueeCrew

A slightly different solution:

RandInt(n): Returns a random integer between 0 and the specified parameter

RandInt(10) returns 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 or 10

RandInt(5000) returns a random whole number between 0 and 5000, such as 741

Cheers,

Mark

ts22

Is there a way to use RandInt and not have it assign duplicate values? I noticed it will give me two 8's instead of just a singular 0-16 for each number.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703