Random numbers creation?

[#1]

Hi All,

How can I randomly assign either 2 or 3 to a field? I know I have to use rand() function but not sure how to make it only assign 2 and 3

Thanks!

[sunny_talwar]

May be like this:

If(Rand() < 0.5, 2, 3)

[sunny_talwar · Accepted solution]

or

If(Rand() <= 0.5, 2, 3)

[trdandamudi]

Just an idea:

Insert a Row number in your table and based on the row number (Whether it is even or odd) assign either 2 or 3 to your field...