Dokumentaatio/Calcin funktiot/SATUNNAISLUKU.PYSYVÄ

From The Document Foundation Wiki
Jump to navigation Jump to search
This page is a translated version of the page Documentation/Calc Functions/RAND.NV and the translation is 55% complete.
Other languages:
English • ‎Nederlands • ‎dansk • ‎español • ‎suomi



Funktion nimi:

SATUNNAISLUKU.PYSYVÄ

Kategoria:

Matemaattinen

Yhteenveto:

Generates a uniformly distributed random number in the range 0 (inclusive) to 1 (exclusive). In contrast to RAND, RAND.NV is a non-volatile function that is not recalculated at every input event.

Syntax:

SATUNNAISLUKU.PYSYVÄ()

Tuottaa:

Tuottaa kokonaisluvun väliltä [0,1).

Argumentit:

None.

Additional details:

  • RAND.NV is a non-volatile function. Such functions are not recalculated at new input events and do not recalculate when selecting Data ▸ Calculate ▸ Recalculate or pressing F9, except when the cell containing the function is selected. Non-volatile functions are recalculated when opening the file.
  • Use the RAND 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 =RAND.NV(), and use Edit ▸ Paste Special (with All and Formulas deselected and Numbers selected).
  • Use Sheet ▸ Fill Cells ▸ Fill Random Number 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 a range other than [0, 1), either:
  • Scale the value returned by RAND.NV to a new range using a formula of the form =(RAND.NV()*(b-a))+a to generate a number in the range [a, b]. For example, the formula =(RAND.NV()*20)-10 would generate random numbers in the range [-10, 10).
  • Use the RANDBETWEEN function or its non-volatile equivalent RANDBETWEEN.NV.

Esimerkkejä:

Template:Calc-Formula/fi Template:Calc-Description/fi Template:Calc-Returns/fi
SATUNNAISLUKU.PYSYVÄ() Generates a random number r in the range 0 ≤ r < 1. The resulting value will not change whenever Calc recalculates. 0,80206289793007

Samankaltaisia LibreOffice-funktioita:

SATUNNAISLUKU

SATUNNAISLUKU.VÄLILTÄ

SATUNNAISLUKU.VÄLILTÄ.PYSYVÄ

ODF standard:

None.

Equivalent Excel functions:

None.