Documentation/Calc Functions/RAND.NV

From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
English

Function name:

RAND.NV

Category:

Mathematical

Summary:

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

Syntax:

RAND()

Returns:

Returns a non-volatile random number between 0(inclusive) and 1(inclusive), i.e. [0,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