Documentation/Calc Functions/SLUMP.NV

    From The Document Foundation Wiki
    This page is a translated version of the page Documentation/Calc Functions/RAND.NV and the translation is 13% complete.
    Outdated translations are marked like this.


    Funktionsnavn:

    SLUMP.NV

    Kategori:

    Matematisk

    Resume:

    Denne funktion producerer et ikke-flygtigt tal ved input. En ikke-flygtig funktion genberegnes ikke ved nye input-hændelser.

    Syntaks:

    SLUMP.NV()

    Returnerer:

    Returnerer et ikke-flygtigt, tilfældigt fal mellem 0 og 1.

    Argumenter:

    Ingen

    Yderligere oplysninger:

    • Funktionen geberegnes ikke, når du trykker på F9, undtagen når markøren står på cellen, der indeholder funktionen. Funktionen genberegnes, når filen åbnes.
    • Use the SLUMP 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 =SLUMP.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 SLUMP.NV to a new range using a formula of the form =(SLUMP.NV()*(b-a))+a to generate a number in the range [a, b]. For example, the formula =(SLUMP.NV()*20)-10 would generate random numbers in the range [-10, 10).
    • Use the SLUMPMELLEM function or its non-volatile equivalent SLUMPMELLEM.NV.

    Eksempler:

    Formula Description Returns
    =SLUMP.NV() Generates a random number r in the range 0 ≤ r < 1. The resulting value will not change whenever Calc recalculates. 0,80206289793007

    Beslægtede LibreOffice-funktioner:

    SLUMP

    SLUMPMELLEM

    SLUMPMELLEM.NV

    ODF standard:

    Ingen

    Tilsvarende Excel-funktioner:

    Ingen