Kako koristiti funkciju PRODUCT u Excelu

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:

=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:

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:

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