Getting real random numbers with RAND() function

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.

Related Trainings

Win a lottary ticket

Win a lottary ticket

Working with advanced functions.