Documentation/How Tos/Calc: RAND function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• Cos
• Sin
• Tan
• Cot
• Acos
• Acot
• Asin
• Atan
• Atan2
• Degrees
• Radians
• Pi

Hyperbolic

• Cosh
• Sinh
• Tanh
• Coth
• Acosh
• Acoth
• Asinh
• Atanh

Rounding and remainders

• Trunc
• Round
• Rounddown
• Roundup
• Ceiling
• Floor
• Even
• Odd
• Mround
• Int
• Quotient
• Mod

Logarithm/Powers

• Exp
• Power
• Log
• Ln
• Log10

Bessel functions

• Besseli
• Besselj
• Besselk
• Bessely

Miscellaneous

• Abs
• Combin
• Combina
• Convert
• Convert Add
• Countblank
• Countif
• Delta
• Erf
• Erfc
• Fact
• Factdouble
• Gcd
• Gcd Add
• Gestep
• Lcm
• Lcm Add
• Multinomial
• Product
• Rand
• Randbetween
• Seriessum
• Sign
• Sqrt
• Sqrtpi
• Subtotal
• Sum
• Sumif
• Sumsq

< Previous Page

Next Page >

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 =RAND(), and use Edit - Paste Special... (with Paste All and Formulas not selected and Numbers selected).

Example:

RAND()

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

RAND()*(b-a) + a

returns a random real number between a and b.

---

See Also

• RANDBETWEEN

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category