Difference between revisions of "Manuals/calci/RANDBETWEEN"

From ZCubes Wiki
Jump to navigation Jump to search
 
(4 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''RANDBETWEEN(lt,ut)'''</div><br/>
+
<div style="font-size:30px">'''RANDBETWEEN (Min,Max)'''</div><br/>
*<math>lt</math>  is the lower integer   
+
*<math>Min</math>  is the lower integer.  
*<math> ut</math> is the upper integer.
+
*<math>Max</math> is the upper integer.
 
+
**RANDBETWEEN(), returns a random number between the numbers you specify
  
 
==Description==
 
==Description==
 
*This function gives the  random number in integers between the specified integers.
 
*This function gives the  random number in integers between the specified integers.
*In <math> RANDBETWEEN(lt,ut), lt</math> is the lower integer and <math>ut</math> is the upper integer this function will return.  
+
*In <math> RANDBETWEEN (Min,Max)</math>, <math>Min</math> is the Lower Integer and <math>Max</math> is the Upper Integer this function will return.  
 
*The generated random numbers are changing each time of the calculation.
 
*The generated random numbers are changing each time of the calculation.
  
 +
==Examples==
 +
#=RANDBETWEEN(-10,-1) = -8
 +
#=RANDBETWEEN(-2,2) = 0
 +
#=RANDBETWEEN(15.1,50.4) = 27
 +
#=RANDBETWEEN(1.1,1.7) = 1
  
==Examples==
+
==Related Videos==
#RANDBETWEEN(-10,-1)=-8
 
#RANDBETWEEN(-2,2)=0
 
#RANDBETWEEN(15.1,50.4)=27
 
#RANDBETWEEN(1.1,1.7)=1
 
  
 +
{{#ev:youtube|PiyApfbQ41c|280|center|RANDBETWEEN}}
  
 
==See Also==
 
==See Also==
 
*[[Manuals/calci/RAND  | RAND ]]  
 
*[[Manuals/calci/RAND  | RAND ]]  
  
 +
==References==
 +
*[http://www.techonthenet.com/excel/formulas/randbetween.php Randbetween]
  
==References==
+
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 15:56, 28 June 2018

RANDBETWEEN (Min,Max)


  • is the lower integer.
  • is the upper integer.
    • RANDBETWEEN(), returns a random number between the numbers you specify

Description

  • This function gives the random number in integers between the specified integers.
  • In , is the Lower Integer and is the Upper Integer this function will return.
  • The generated random numbers are changing each time of the calculation.

Examples

  1. =RANDBETWEEN(-10,-1) = -8
  2. =RANDBETWEEN(-2,2) = 0
  3. =RANDBETWEEN(15.1,50.4) = 27
  4. =RANDBETWEEN(1.1,1.7) = 1

Related Videos

RANDBETWEEN

See Also

References