Multiplies all the numbers given as arguments and returns the product.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 50
Multiplies 5 by 10.
=PRODUCT(A1:A3)결과: 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.