Documentation/Calc Functions/RAND.NV

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

Function name:

RAND

Category:

Mathematical

Summary:

This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events.

Im-jabber.svg

Note:
This function is available since LibreOfficeDev 7.0.

Syntax:

RAND()

Returns:

Returns a non-volatile random number between 0 and 1.

Arguments:

None.

Additional details:

The function does not recalculate when pressing F9, except when the cursor is on the cell containing the function. The function is recalculated when opening the file.

Examples:

Formula Description Returns
=RAND.NV() a non-volatile random number between 0 and 1 0.80206289793007

Related LibreOffice functions:

RAND

RANDBETWEEN.NV

ODF standard:

None

Equivalent Excel functions:

None