Documentation/Calc Functions/SLUMP.NV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

Calc Functions Home | List of functions | Abbreviations

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:

Formel	Beskrivelse	Returnerer
=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

Relaterede (eller lignende) Excel-funktioner:

Ingen