Multiplies all the numbers given as arguments and returns the product.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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)Résultat : 50
Multiplies 5 by 10.
=PRODUCT(A1:A3)Résultat : 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.