Multiplies all the numbers given as arguments and returns the product.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
PRODUCT(number1, [number2], …)The PRODUCT function is used to multiply a series of numbers, cell references, or ranges. It is particularly useful for calculating the product of large datasets where manual multiplication would be inefficient.
=PRODUCT(5, 10)Kết quả: 50
Multiplies 5 by 10.
=PRODUCT(A1:A3)Kết quả: 6
Multiplies the values in cells A1, A2, and A3 (assuming they contain 1, 2, and 3).
The PRODUCT function ignores cells that contain text or empty values.