Difference between revisions of "Manuals/calci/RAND"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
<div style="font-size:30px">'''RAND()'''</div><br/>
 
<div style="font-size:30px">'''RAND()'''</div><br/>
 +
**RAND(),returns a random number between 0 and 1.
  
 
==Description==
 
==Description==
Line 22: Line 23:
 
==References==
 
==References==
 
*[http://www.techonthenet.com/excel/formulas/rand.php Rand Function]
 
*[http://www.techonthenet.com/excel/formulas/rand.php Rand Function]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 14:52, 28 June 2018

RAND()


    • RAND(),returns a random number between 0 and 1.

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

Related Videos

RAND

See Also

References