Difference between revisions of "Manuals/calci/RANDBETWEEN"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (6 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''RANDBETWEEN (Min,Max)'''</div><br/> |
| + | *<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== | |
| + | *This function gives the random number in integers between the specified integers. | ||
| + | *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. | ||
| − | + | ==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== | |
| + | *[[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)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Min} is the lower integer.
- is the upper integer.
- RANDBETWEEN(), returns a random number between the numbers you specify
is the upper integer.
Description
- This function gives the random number in integers between the specified integers.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle RANDBETWEEN (Min,Max)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Min} is the Lower Integer and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Max} 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