Difference between revisions of "Manuals/calci/RANDBETWEEN"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by 2 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)</math>, <math>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.
  
Line 13: Line 14:
 
#=RANDBETWEEN(15.1,50.4) = 27
 
#=RANDBETWEEN(15.1,50.4) = 27
 
#=RANDBETWEEN(1.1,1.7) = 1  
 
#=RANDBETWEEN(1.1,1.7) = 1  
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|PiyApfbQ41c|280|center|RANDBETWEEN}}
  
 
==See Also==
 
==See Also==
Line 19: Line 24:
 
==References==
 
==References==
 
*[http://www.techonthenet.com/excel/formulas/randbetween.php Randbetween]
 
*[http://www.techonthenet.com/excel/formulas/randbetween.php Randbetween]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 14: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