Difference between revisions of "Manuals/calci/RANDBETWEEN"
Jump to navigation
Jump to search
(5 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | <div style="font-size:30px">'''RANDBETWEEN( | + | <div style="font-size:30px">'''RANDBETWEEN (Min,Max)'''</div><br/> |
− | *<math> | + | *<math>Min</math> is the lower 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( | + | *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 | ||
− | == | + | ==Related Videos== |
− | |||
− | |||
− | |||
− | |||
+ | {{#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] | ||
− | + | ||
+ | |||
+ | |||
+ | *[[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
- =RANDBETWEEN(-10,-1) = -8
- =RANDBETWEEN(-2,2) = 0
- =RANDBETWEEN(15.1,50.4) = 27
- =RANDBETWEEN(1.1,1.7) = 1
Related Videos
See Also
References