Documentation/Calc Functions/PRODUKT

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:

PRODUKT

Kategori:

Matematisk

Resume:

Multiplicerer alle tal givet som argumenter og returnerer produktet.

Syntaks:

PRODUKT(Number 1 [; Number 2 [; … [; Number 255]]])

Returnerer:

Returnerer et reelt tal, som er produktet af alle inddata-argumenter, dvs. tal 1 * tal 2 * tal 3 * ...

Argumenter:

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

• A real number, or an expression that evaluates to a real number.
• A reference to a single cell containing a real number.
• A simple reference to a cell range containing real numbers (for example, A1:B9).
• The name of a named range, comprising cells containing real numbers.
• The name of a database range, comprising cells containing real numbers.
• An inline array of real numbers (for example, {1.1, 2.2, 3.3, 4.4}).

Note that although PRODUKT can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of real numbers processed could be many more than 255.

The following conditions (including errors) may be encountered:

• If any argument is a string in quotation marks, then PRODUKT reports a #VÆRDI! error.
• Text and empty cells within a data range are ignored.
• If there are no supplied numbers, or any supplied value is equal to 0, then PRODUKT returns the value 0.
• If only one value is supplied, then PRODUKT returns that value.

Yderligere oplysninger:

• * Cellereferencen er nyttig, når man ønsker flere spredte sæt af celler, i hvilket tilfælde

PRODUKT(A_i:A_m;B_k:B_l) kan anvendes, hvilket svarer til A_i*A_i+1*..*A_m*B_k*B_k+1*...B_l.

[math]\displaystyle{ \text{\lt span lang="en" dir="ltr" class="mw-content-ltr"\gt PRODUCT\lt /span\gt }(N_{1}; N_{2}; ...; N_{k})=N_{1}\times N_{2}\times ...\times N_{k} }[/math]

• * Hvis en celle ikke indeholder en numerisk værdi, bliver den ignoreret.

Eksempler:

Formel	Beskrivelse	Returnerer
=PRODUKT(2; 3; 4)	Here the function calculates [math]\displaystyle{ 2\times3\times4 }[/math] and returns the result.	24
=PRODUKT(A1:A3; B1:B2) where cells A1, A2, A3, B1, and B2 contain the numbers 2.2, 3, -5, 1.3, and -7 respectively.	Here the function calculates [math]\displaystyle{ 2.2\times3\times-5\times1.3\times-7 }[/math] and returns the result.	300,3
=PRODUKT({2; 4; 6; 8})	Here the function calculates [math]\displaystyle{ 2\times4\times6\times8 }[/math] and returns the result.	384

Beslægtede LibreOffice-funktioner:

IMAGPRODUKT

SUM

ODF standard:

Section 6.16.47, part2

Relaterede (eller lignende) Excel-funktioner:

PRODUCT