Kako koristiti funkciju PRODUCT u Excelu
Český | Angličtina |
---|---|
SOUČIN (funkce) | PRODUCT |
Multiplying Numerical Values in Excel and Google Sheets
The PRODUCT function is an invaluable tool in spreadsheet applications like Microsoft Excel and Google Sheets. Its primary use is to multiply a series of numbers or cell values together to return their product.
The syntax for this function is:
=PRODUCT(number1, [number2], ...)
- number1, number2, … – these are the values you wish to multiply. These arguments can be numbers, arrays of numbers, or cell references that contain numbers. At least one number is required for the calculation.
Let’s look at an example:
A |
---|
3 |
4 |
5 |
=PRODUCT(A1:A3)
This formula multiplies the numbers 3, 4, and 5, resulting in a product of 60.
Practical Uses of the PRODUCT Function
1. Calculating Total Material Requirement for Production
Consider a table that lists the quantity of pieces and the weight per piece for a manufacturing process:
Product | Quantity (B) | Weight per Piece (C) |
---|---|---|
Screw | 100 | 0.05 |
Nut | 150 | 0.03 |
To calculate the total weight for each item, you can use the PRODUCT function:
=PRODUCT(B2, C2) // for screws =PRODUCT(B3, C3) // for nuts
The results of these formulas show that the total weight of screws is 5 kg and that of nuts is 4.5 kg.
2. Calculating Compound Interest
Imagine you have an account with an initial deposit and you want to calculate the final value after several years of compound interest:
Year | Interest Rate (%) |
---|---|
1 | 1.02 |
2 | 1.03 |
3 | 1.04 |
The deposit is CZK 10,000. Using the PRODUCT function, we get:
=10,000 * PRODUCT(B2:B4)
This operation results in the final account value after three years, applying the listed annual interest rates.
Více informací: https://support.microsoft.com/cs-cz/office/součin-funkce-8e6b5b24-90ee-4650-aeec-80982a0512ce