# Difference between revisions of "Documentation/How Tos/Calc: RAND function"

From Apache OpenOffice Wiki

< Documentation | How Tos

(Initial content) |
(added that 0<=n<1) |
||

Line 3: | Line 3: | ||

== RAND == | == RAND == | ||

Returns a random number between 0 and 1. | Returns a random number between 0 and 1. | ||

− | |||

=== Syntax: === | === Syntax: === | ||

<tt>'''RAND()'''</tt> | <tt>'''RAND()'''</tt> | ||

− | : This function produces a new random number each time Calc recalculates. | + | : This function produces a new random number each time Calc recalculates, greater than or equal to 0, and less than 1. |

: To force Calc to recalculate manually press Shift+Ctrl+F9. | : To force Calc to recalculate manually press Shift+Ctrl+F9. | ||

: To generate a random number which never recalculates, copy a cell containing <tt>'''=RAND()'''</tt>, 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 <tt>'''=RAND()'''</tt>, and use Edit - Paste Special... (with Paste All and Formulas <u>not</u> selected and Numbers selected). | ||

− | |||

=== Example: === | === Example: === | ||

<tt>'''RAND()'''</tt> | <tt>'''RAND()'''</tt> | ||

− | : returns a random number between <tt>'''0'''</tt> and <tt>'''1'''</tt>. | + | : returns a random number between <tt>'''0'''</tt> (inclusive) and <tt>'''1'''</tt> (exclusive). |

<tt>'''RAND()*(b-a) + a'''</tt> | <tt>'''RAND()*(b-a) + a'''</tt> | ||

: returns a random real number between <tt>'''a'''</tt> and <tt>'''b'''</tt>. | : returns a random real number between <tt>'''a'''</tt> and <tt>'''b'''</tt>. | ||

− | |||

=== See also: === | === See also: === |

## Revision as of 16:09, 3 January 2008

## RAND

Returns a random number between 0 and 1.

### Syntax:

**RAND()**

- This function produces a new random number each time Calc recalculates, greater than or equal to 0, and less than 1.

- To force Calc to recalculate manually press Shift+Ctrl+F9.

- To generate a random number which never recalculates, copy a cell containing
, and use Edit - Paste Special... (with Paste All and Formulas**=RAND()**__not__selected and Numbers selected).

### Example:

**RAND()**

- returns a random number between
(inclusive) and**0**(exclusive).**1**

**RAND()*(b-a) + a**

- returns a random real number between
and**a**.**b**