writer
2,661
edits
Changes
→Examples
|- class="even"
|- class="even"
| class="sshl_f" | TRUE
| class="sshl_f" | FALSE
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
=PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns ''-20'' as a result.
=PRODUCT(B1:B3) : Calculates the product of values in the range B1 to B3. Empty cell is ignored. Returns ''-20'' as a result.
=PRODUCT(B4,2) : Calculates the product of reference B4 and 2. Text is ignored. Returns ''2'' as a result.
=PRODUCT(B4,2) : Calculates the product of reference B4 and 2. Text is ignored. Returns ''2'' as a result.
==See also==
*[[Manuals/calci/SUM| SUM]]
*[[Manuals/calci/AVERAGE| AVERAGE]]
==References==
*[http://en.wikipedia.org/wiki/Product_(mathematics) PRODUCT]