Documentation/Calc Functions/RANDBETWEEN.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:

RANDBETWEEN.NV

Category:

Mathematical

Summary:

Returns an non-volatile integer random number between integers Bottom and Top (both inclusive). A non-volatile function is not recalculated at new input events or pressing F9. However, the function is recalculated when pressing F9 with the cursor on the cell containing the function, when opening the file, and when Top or Bottom are recalculated.

Syntax:

RANDBETWEEN.NV(Bottom; Top)

Returns:

Returns an non-volatile integer random number in a specified range.

Arguments:

Bottom is an integer value or a reference to the cell containing that value which is the lower bound.

Top is an integer value or a reference to the cell containing that value which is the upper bound.

  • If Bottom is greater than Top, the function returns an error value.
  • If both Bottom and Top are equal then the function returns that same value.
  • If arguments are not integer, then they are rounded to nearest integer either above or below, i.e. they truncated to integers. For eg. 5.4 is rounded to 5, 5.6 to 6 and 5.5 to 6.

Additional details:

None

Examples:

Formula Description Returns
=RANDBETWEEN.NV(20;30) a non-volatile random integer between 20 and 30 23
=RANDBETWEEN.NV(A1;30) where A1 has 5 a non-volatile integer between the value of cell A1 and 30. The function is recalculated when the contents of cell A1 change 7
=RANDBETWEEN.NV(20.4;30.8) a non-volatile random integer between 20 and 31, rounding to closest integers 27

Related LibreOffice functions:

RANDBETWEEN

RAND.NV

ODF standard:

None

Equivalent Excel functions:

None