Rand function.

[#1]

Hi everyone, if someone were to answer this I'd be really grateful.

Is it possible to generate a limited range using the rand function?

I was thinking about something like this.

RAND() >= 0.75 AND <= 0.95

[christophebrault · Accepted solution]

hi,

try this expression :

=0.75+rand()/5

[#3]

Might I ask how you came up with your solution?

[#4]

I don't understaund that

[#5]

Rand generates a decimal out put between zero and one.

Dividing the range by 5 will mean the output will be between 0 and 0.20.

So overall range will be 0.75+0 to 0.75+0.20.