Difference between revisions of "Manuals/calci/RANDBETWEEN"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*<math>lt</math> is the lower integer | *<math>lt</math> is the lower integer | ||
*<math> ut</math> is the upper integer. | *<math> ut</math> is the upper integer. | ||
| − | |||
==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 | + | *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. |
*The generated random numbers are changing each time of the calculation. | *The generated random numbers are changing each time of the calculation. | ||
| − | |||
==Examples== | ==Examples== | ||
| − | #RANDBETWEEN(-10,-1)=-8 | + | #=RANDBETWEEN(-10,-1) = -8 |
| − | #RANDBETWEEN(-2,2)=0 | + | #=RANDBETWEEN(-2,2) = 0 |
| − | #RANDBETWEEN(15.1,50.4)=27 | + | #=RANDBETWEEN(15.1,50.4) = 27 |
| − | #RANDBETWEEN(1.1,1.7)=1 | + | #=RANDBETWEEN(1.1,1.7) = 1 |
| − | |||
==See Also== | ==See Also== | ||
*[[Manuals/calci/RAND | RAND ]] | *[[Manuals/calci/RAND | RAND ]] | ||
| − | |||
==References== | ==References== | ||
Revision as of 04:29, 22 January 2014
RANDBETWEEN(lt,ut)
- is the lower integer
- is the upper integer.
is the lower integer
is the upper integer.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