Documentation/Calc Functions/MINDSTE.FÆLLES.MULTIPLUM

    From The Document Foundation Wiki
    This page is a translated version of the page Documentation/Calc Functions/LCM and the translation is 3% complete.
    Outdated translations are marked like this.
    Other languages:


    Funktionsnavn:

    MINDSTE.FÆLLES.MULTIPLUM

    Kategori:

    Matematisk

    Resume:

    MINDSTE.FÆLLES.MULTIPLUM giver det mindste fælles multiplum af et eller flere positive heltal.

    Syntaks:

    MINDSTE.FÆLLES.MULTIPLUM(Integer 1 [; Integer 2 [; … [; Integer 255]]])

    Returnerer:

    Returnerer et heltal, som er det mindste fælles multiplum af et eller flere positive heltal, der er opgivet som inddata.

    Argumenter:

    Tal 1, tal 2, … , tal 255 er tal, referencer til celler eller til celleområder med tal.

    • * Hvis noget argument er negativt, returnerer funktionen en fejlværdi.
    • Hvis noget argument ikke er et heltal, returnerer funktionen en heltals mindste fælles divisor. For eksempel vil MINDSTE.FÆLLES.MULTIPLUM (2,5;5) returnere 10, mens MINDSTE.FÆLLES.MULTIPLUM (8;2,2) returnerer 8.
    • A reference to a single cell containing a positive integer.
    • A simple reference to a cell range containing positive integers (for example, A1:B9).
    • The name of a named range, comprising cells containing positive integers.
    • The name of a database range, comprising cells containing positive integers.
    • An inline array of positive integers (for example, {1, 2, 3, 4}).

    Note that although MINDSTE.FÆLLES.MULTIPLUM can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of positive integers processed could be many more than 255.

    The following conditions (including errors) may be encountered:

    • If any argument is a string in quotation marks, or a reference to a single cell that contains a string rather than a positive integer, then MINDSTE.FÆLLES.MULTIPLUM reports a #VÆRDI! error.
    • Text and empty cells within a data range are ignored.
    • If any value is negative, then MINDSTE.FÆLLES.MULTIPLUM reports an invalid argument error (Fejl:502).
    • If any value is not an integer, that value is truncated to its floor value.
    • If after any truncation all supplied values are equal to 0, then MINDSTE.FÆLLES.MULTIPLUM returns the value 0.

    Yderligere oplysninger:

    • Hvis der er givet to positIve heltal, er a*b=MINDSTE.FÆLLES.MULTIPLUM(a;b)*STØRSTE.FÆLLES.DIVISOR(a;b)
    • For two positive integers i and j, the following relationship holds:

    [math]\displaystyle{ i\times j~=~\text {\lt span lang="en" dir="ltr" class="mw-content-ltr"\gt LCM\lt /span\gt }(i, j) \times \text{\lt span lang="en" dir="ltr" class="mw-content-ltr"\gt GCD\lt /span\gt }(i, j) }[/math]

    STØRSTE.FÆLLES.DIVISOR(i, j) is the greatest common divisor of i and j (see STØRSTE.FÆLLES.DIVISOR).
    • The least common multiple (MINDSTE.FÆLLES.MULTIPLUM) is sometimes referred to as the lowest common multiple or the smallest common multiple.
    • For more background information, visit Wikipedia’s Least common multiple page.

    Eksempler:

    Formula Description Returns
    =MINDSTE.FÆLLES.MULTIPLUM(16; 32; 24; 40) Here the function returns 480, because that is the lowest common multiple of 16, 24, 32, and 40. 480
    =MINDSTE.FÆLLES.MULTIPLUM(B1:B3) where cells B1, B2, and B3 contain the numbers 9, 12, and 6 respectively. Here the function returns 36, because that is the lowest common multiple of 6, 9, and 12. The formula =MINDSTE.FÆLLES.MULTIPLUM(B1; B2; B3) would give the same result. 36
    =MINDSTE.FÆLLES.MULTIPLUM(3,2; 5,6) The two argument values are truncated to 3 and 5 respectively. Here the function returns 15, because that is the lowest common multiple of 3 and 5. 15
    =MINDSTE.FÆLLES.MULTIPLUM({2; 4; 6; 8}) Here the function returns 24, because that is the lowest common multiple of 2, 4, 6, and 8. 24

    Beslægtede LibreOffice-funktioner:

    STØRSTE.FÆLLES.DIVISOR

    MINDSTE.FÆLLES.MULTIPLUM_EXCEL2003

    ODF standard:

    Tilsvarende Excel-funktioner:

    LCM