Difference between revisions of "Documentation/How Tos/Calc: RANDBETWEEN function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
| Line 8: | Line 8: | ||
=== Syntax: === | === Syntax: === | ||
| − | <tt>'''RANDBETWEEN( | + | <tt>'''RANDBETWEEN(bottom; top)'''</tt> |
| − | : Returns an integer random number between integers <tt>''' | + | : Returns an integer random number between integers <tt>'''bottom'''</tt> and <tt>'''top'''</tt> (both inclusive). |
: This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Ctrl+F9. | : This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Ctrl+F9. | ||
| − | : To generate a random number which never recalculates, copy a cell containing this function, and use Edit - Paste Special... (with Paste All and Formulas <u>not</u> selected and Numbers selected). | + | : To generate a random number which never recalculates, copy a cell containing this function, and use '''Edit - Paste Special...''' (with '''Paste All''' and '''Formulas''' <u>not</u> selected and '''Numbers''' selected). |
: An alternative to this function not requiring the Analysis AddIn would be: | : An alternative to this function not requiring the Analysis AddIn would be: | ||
| − | : <tt>'''INT(RAND()*( | + | : <tt>'''INT(RAND()*(top-bottom+1))+bottom'''</tt>. |
Revision as of 08:33, 25 December 2007
RANDBETWEEN
Returns an integer random number in a specified range.
This function is only available if the Analysis AddIn is installed.
Syntax:
RANDBETWEEN(bottom; top)
- Returns an integer random number between integers bottom and top (both inclusive).
- This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Ctrl+F9.
- To generate a random number which never recalculates, copy a cell containing this function, and use Edit - Paste Special... (with Paste All and Formulas not selected and Numbers selected).
- An alternative to this function not requiring the Analysis AddIn would be:
- INT(RAND()*(top-bottom+1))+bottom.
Example:
RANDBETWEEN(20; 30)
- returns an integer between 20 and 30 (inclusive).
