Documentation/Calc Functions/POTENS

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:

POTENS

Kategori:

Matematisk

Resume:

Returnerer et tal opløftet til et andet tal.

Syntaks:

POTENS(Base; Exponent)

Returnerer:

Returnerer et reelt tal, som er base opløftet til eksponens.

Argumenter:

Base er et reelt tal eller en reference til den celle, der indeholder det tal, som er base-værdien for funktionen POTENS.

Eksponent er et reelt tal eller en reference til den celler, der indeholder det tal, som basen opløftes til.

• * Hvis eksponenten ikke er et heltal og basen er negativ, returnerer funktionen en numerisk fejlværdi (#NUM!).
• Hvis eksponenten er negativ og basen er 0, returnerer funktionen en numerisk fejlværdi (#NUM!).
• Hvis både eksponenten og basen er 0, returnerer funktionen 1.
• If Base is equal to 0 and Exponent is negative, then POTENS reports a #NUM! error.
• If Base is negative and Exponent is non-integer, then POTENS reports a #NUM! error.
• If both Exponent and Base are 0, then POTENS returns 1.

Yderligere oplysninger:

• Det samme resultat kan nås ved at bruge eksponentierings-operatoren ^: base^eksponent.
• POTENS cannot be used with a negative base and a non-integer exponent. This means, for example, that you cannot use POTENS to solve expressions such as [math]\displaystyle{ (-1)^{0.5} }[/math] – this is equivalent to [math]\displaystyle{ \sqrt{-1} }[/math] which has no real solution.
• Calc's exponentiation operator (^) produces the same result as that obtained from POTENS. For example, the formula =2^3 gives the same result as =POTENS(2; 3).
• For more background information about the exponentiation operator, visit Wikipedia’s Exponentiation page.

Eksempler:

Formel	Beskrivelse	Returnerer
=POTENS(5; 3)	Here the function raises 5 to the power of 3. This is equal to [math]\displaystyle{ 5\times5\times5 }[/math].	125
=POTENS(D1; D2) where cells D1 and D2 contain the numbers 5.5 and 3.7 respectively.	Here the function raises 5.5 to the power of 3.7.	548,708832614192
=POTENS(2; −3)	Here the function raises 2 to the power of -3. The value 2-3 is equal to [math]\displaystyle{ \frac{1}{2^3} }[/math] or [math]\displaystyle{ \frac{1}{8} }[/math].	0,125
=POTENS(−5; 3)	Here the function raises -5 to the power of 3. This is equal to [math]\displaystyle{ -5 \times -5 \times -5 }[/math].	−125
=POTENS(−3; −4)	Here the function raises -3 to the power of -4. This is equal to [math]\displaystyle{ \frac{1}{(-3)^4} }[/math] or [math]\displaystyle{ \frac{1}{81} }[/math].	0,012345679012346

Beslægtede LibreOffice-funktioner:

EKSP

LN

LOG

LOG10

ODF standard:

Section 6.16.46, part2

Relaterede (eller lignende) Excel-funktioner:

POWER