If you want to get random real numbers, you use RAND() function. If you do not write anything in the paranthesis, the default range will be 0-100.

In second and third examples, the range starts from 0.

If you want to get a random real number between two numbers which you decide, let's say a and b, you use such formula =RAND() * (b - a) + a.