Difference between revisions of "Manuals/calci/RAND"

From ZCubes Wiki
Jump to navigation Jump to search
Line 17: Line 17:
  
 
==References==
 
==References==
 +
*[http://www.techonthenet.com/excel/formulas/rand.php Rand Function]

Revision as of 13:52, 14 May 2015

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.

Examples

  1. =RAND() = 0.37205533031374216
  2. =RAND()*100 = 46.92529523745179
  3. =RAND()+25 = 25.684887402923778

See Also

References