Documentation/Calc Functions/RUND.NED

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:

RUND.NED

Kategori:

Matematisk

Resume:

Afrunder et tal nedad, nærmende sig nul eller til en vis nøjagtighed.

Syntaks:

RUND.NED(Number[; Count])

Returnerer:

Returnerer tallet nedrundet (nærmende sig 0) til antal decimalpladser.

Argumenter:

Tallet er et reelt tal eller en refernce til cellen, der indeholder det, som skal rundes ned til et bestemt antal decimalpladser.

Antallet er et heltal eller en reference til en celle, der indeholder det heltal, som er det antal decimalpladser, som tallet skal rundes ned til.

• Hvis antallet er udeladt eller 0, runder funktionen ned til et heltal. Hvis antallet er negativt, runder funktionen ned til det nærmeste 10, 100, 1000 osv.
• If Count is equal to zero, then rounding is to the next integer toward 0.
• If Count is a negative integer, then rounding is to the left of the decimal separator. For example, if Count is equal to -1 then numbers are rounded (toward 0) to the next multiple of 10; if Count is equal to -2 then numbers are rounded (toward 0) to the next multiple of 100; and so on. The value returned by RUND.NED will always be an integer when Count is negative.

The following conditions (including errors) may be encountered:

• If either Number or Count is non-numeric, then RUND.NED reports a #VÆRDI! error.
• If Count is a non-integer value, then it is rounded to the next integer in the direction of 0.

Yderligere oplysninger:

• Denne funktion afrunder imod nul, se RUND.OP og RUND.NED som alternativer.

1. Make sure that the number of displayed decimal places is not affected by the setting of the Limit decimals for general number format option in the General Calculations area of the Tools ▸ Options ▸ LibreOffice Calc ▸ Calculate dialog (LibreOffice ▸ Preferences ▸ LibreOffice Calc ▸ Calculate on macOS).
2. Access the Numbers tab on the Format Cells dialog (Format ▸ Cells or equivalent interaction) to make sure that relevant cells do not have formatting applied that affects the number of displayed decimal places.

• Calc's RUND.NED and AFKORT perform identical functions.

Eksempler:

Formel	Beskrivelse	Returnerer
=RUND.NED(2,348; 2)	Here the function rounds 2.348 toward 0, to 2 decimal places.	2,34
=RUND.NED(D1; D2) where cells D1 and D2 contain the numbers -32.4834 and 3.2 respectively.	The value of the Count argument is truncated to 3. Here the function rounds -32.4834 toward 0, to 3 decimal places.	−32,483
=RUND.NED(2,648; 0)	Here the function rounds 2.648 toward 0, to the next integer. The alternative formula =RUND.NED(2.648) returns the same value.	2
=RUND.NED(−45,67)	Here the function rounds -45.67 toward 0, to the next integer.	−45
=RUND.NED(987,65; −2)	Here the function rounds 987.65 toward 0, to the next hundred.	900

Beslægtede LibreOffice-funktioner:

HELTAL

AFRUND

RUND.OP

AFKORT

ODF standard:

Section 6.17.6, part2

Relaterede (eller lignende) Excel-funktioner:

ROUNDDOWN