Difference between revisions of "Manuals/calci/RAND"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
==Examples== | ==Examples== | ||
| − | #RAND()=0.37205533031374216 | + | #=RAND() = 0.37205533031374216 |
| − | #RAND()*100=46.92529523745179 | + | #=RAND()*100 = 46.92529523745179 |
| − | #RAND()+25=25.684887402923778 | + | #=RAND()+25 = 25.684887402923778 |
==See Also== | ==See Also== | ||
Revision as of 04:23, 22 January 2014
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 and , we can use RAND()*(b-a)+a.
- Suppose we want to keep the same rand numbers for calculation, we can enter =RAND() in the formula bar.
and 
, we can use RAND()*(b-a)+a.Examples
- =RAND() = 0.37205533031374216
- =RAND()*100 = 46.92529523745179
- =RAND()+25 = 25.684887402923778
See Also