Difference between revisions of "Manuals/calci/RAND"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 4 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==
*This function gives the real numbers ,circulated in a uniformed way.
+
*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 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.
 
*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.  
+
*To find the random real number between <math>a</math> and <math>b</math>, 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.
+
*Suppose we want to keep the same rand numbers for calculation, we can enter =RAND() in the formula bar.
  
 +
==Examples==
 +
#=RAND() = 0.37205533031374216
 +
#=RAND()*100 = 46.92529523745179
 +
#=RAND()+25 = 25.684887402923778
  
==Examples==
+
==Related Videos==
#RAND()=0.37205533031374216
 
#RAND()*100=46.92529523745179
 
#RAND()+25=25.684887402923778
 
  
 +
{{#ev:youtube|PiyApfbQ41c|280|center|RAND}}
  
 
==See Also==
 
==See Also==
*[[Manuals/calci/RANDBETWEEN  | RANDBETWEEN ]]  
+
*[[Manuals/calci/RANDBETWEEN  | RANDBETWEEN ]]
  
 +
==References==
 +
*[http://www.techonthenet.com/excel/formulas/rand.php Rand Function]
  
==References==
+
 
 +
 
 +
 
 +
*[[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