Documentation/Calc Functions/LOG

From The Document Foundation Wiki
Jump to navigation Jump to search
This page is a translated version of the page Documentation/Calc Functions/LOG and the translation is 5% complete.
Outdated translations are marked like this.
Other languages:
English • ‎Nederlands • ‎dansk • ‎español • ‎עברית

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

Funktionsnavn:

LOG

Kategori:

Matematisk

Resume:

Returnerer logaritmen af et tal til den specificerede base.

Syntaks:

LOG(Number [; Base])

Returnerer:

Returnerer et reelt tal, som er den logaritmiske værdi af tallet for basen.

Argumenter:

Tallet er den positive, reelle værdi eller en reference til en celle, der indeholder det tal, hvis logaritme skal beregnes.

Base (valgfri) er den positive reelle værdi eller en reference til cellen, der er base for logaritme-beregningen. Hvis den er udeladt, antages base 10.

Hvis ét af argumenterne er negativt eller 0, returnerer funktionen en fejlværdi.

Yderligere oplysninger:

GIFerne herunder illustrerer logaritme-funktionen for base e, base 2 og base 10:

LOG base-e
LOG base-2
LOG base-10

[math]\displaystyle{ \text{log}_b(x)~=~\frac{\text{log}_d(x)}{\text{log}_d(b)} }[/math]

This formula is valid for positive real numbers x, b, and d, such that neither b nor d is equal to 1.
  • The figure below illustrates the LOG function when Base is set to 2 (known as binary logarithms).
LOG base-2
  • See LN for the corresponding illustration when Base is set to the mathematical constant e (natural logarithms).
  • See LOG10 for the corresponding illustration when Base is set to 10 (common logarithms).

Eksempler:

Template:Calc-Formula/da Template:Calc-Description/da Template:Calc-Returns/da
=LOG(3,5; 5) Here the function returns the logarithm to base 5 of 3.5. 0,778385397048775
=LOG(0,5; 4) Here the function returns the logarithm to base 4 of 0.5. -0,5
=LOG(D1; D2) where cells D1 and D2 contain the numbers 1 and 9 respectively. Here the function returns the logarithm to base 9 of 1 (the logarithm of 1 is always zero, for any base). 0
=LOG(2,5; 5,7) Here the function returns the logarithm to base 5.7 of 2.5. 0,526462820777384
=LOG(POTENS(7; 34); 7) Here the function returns the logarithm to base 7 of 7 raised to the power of 34, which is 34. 34
=POTENS(13; LOG(789, 13)) Here the function returns 13 to the power of the logarithm to base 13 of 789, which is 789. 788,999999999999

Beslægtede LibreOffice-funktioner:

EKSP

LN

LOG10

POTENS

ODF standard:

Tilsvarende Excel-funktioner:

LOG