Combine RAND and RANDBETWEEN
RAND returns a real number between 0 and 1.
RANDBETWEEN returns an integer between 2 user-chosen numbers.
We should have a single function that lets you choose the number range and lets you choose whether the value returned is an integer or real number.
To do this, either modify RAND() to take 3 optional parameters or add an optional "number set" parameter to RANDBETWEEN. The function that is not modified becomes a compatibility function.
2
votes
Please try the new RANDARRAY function, which has more options than RAND and RANDBETWEEN.