Documentation/Calc Functions/SLUMP.NV

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 12% complete.
Outdated translations are marked like this.
Other languages:
English • ‎Nederlands • ‎dansk • ‎español • ‎suomi

Template:Documentation/Calc Functions/Func Page Links/da

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 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.

Eksempler:

Template:Calc-Formula/da Template:Calc-Description/da Template:Calc-Returns/da
=RAND.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:

RAND

RANDBETWEEN

RANDBETWEEN.NV

ODF standard:

Ingen

Tilsvarende Excel-funktioner:

Ingen