Documentation/Calc Functions/RANDBETWEEN.NV/fi

Funktion nimi:
SATUNNAISLUKU.VÄLILTÄ.PYSYVÄ

Kategoria:
Matemaattinen

Yhteenveto:
Generates a random integer that lies in a specified range. In contrast to RANDBETWEEN, RANDBETWEEN.NV is a non-volatile function that is not recalculated at every input event.

Syntax:
RANDBETWEEN.NV(Bottom; Top)

Tuottaa:
Tuottaa satunnaisen kokonaisluvun, joka sijaitsee määritellyllä välillä [Alinhaluttuluku, Ylinhaluttuluku].

Argumentit:
Alinhaluttuluku on halutun alueen alaraja. Sen on oltava kokonaislukuarvo tai viittaus kokonaisluvun sisältävään soluun.

Ylinhaluttuluku on halutun alueen yläraja. Sen on oltava kokonaislukuarvo tai viittaus kokonaisluvun sisältävään soluun.


 * If either Bottom or Top is non-numeric, then RANDBETWEEN.NV reports a #VALUE! error.
 * If Bottom is greater than Top, then RANDBETWEEN.NV reports an invalid argument error (Err:502).
 * If either Bottom or Top is a non-integer value, then RANDBETWEEN.NV rounds it away from 0 to the next integer value (positive values rounded towards +∞, negative values rounded towards -∞).
 * If Bottom and Top are equal (after any rounding), then RANDBETWEEN.NV returns their common value.

Additional details:

 * RANDBETWEEN.NV is a non-volatile function. Such functions are not recalculated at new input events and do not recalculate when selecting or pressing F9, except when the cell containing the function is selected. Non-volatile functions are recalculated when opening the file.


 * Use the RANDBETWEEN function for a volatile equivalent that satisfies ODF 1.2 and is compatible with Microsoft Excel.


 * To generate random numbers that never recalculate, either:
 * Copy cells containing, and use  (with All and Formulas deselected and Numbers selected).
 * Use to fill a selected cell range with random numbers, generated in accordance with the flexible settings available through the Random Number Generator dialog.


 * To generate numbers in the range [0, 1), use the RAND function or its non-volatile equivalent RAND.NV.

Samankaltaisia LibreOffice-funktioita:
SATUNNAISLUKU

SATUNNAISLUKU.PYSYVÄ

SATUNNAISLUKU.VÄLILTÄ

ODF standard:
None.

Equivalent Excel functions:
None.