RAND()
Description
- This function gives the real numbers ,circulated in a uniformed way.
- The random numbers generate a sequence of numbers which is lying between 0 and 1.
- The generated random numbers are changing each time of the calculation.
- To Find the random real number between a and b, we can use RAND()*(b-a)+a.
- Suppose we want to keep the same rand numbers for calcultion, we can enter =RAND() in the formula bar.
Examples
- RAND()=0.37205533031374216
- RAND()*100=46.92529523745179
- RAND()+25=25.684887402923778
See Also