PRODUCT

Calculates the product of the received numbers and lists of numbers by multiplying every number together

Usage

PRODUCT(number_or_list...)

Parameters

number_or_list	(Required) A number or a list of numbers to include in the product
...	There can be many number_or_list. They are multiplied together.

Examples

Example	With these variables	Result
PRODUCT(numbers)	numbers is [10, 20, 30]	6000
PRODUCT(3, 25)	(None)	75
PRODUCT(a_number, numbers)	a_number is 100 numbers is [10, 20, 30]	600000

Reminders

A text containing digits is not handled as a number. To have an actual number:

use the @NUMBER_QUESTION to set the variable
write a numeric value directly in the code without quotes, ex: age >= 18
use a function which converts to a number: NUMBER(text_containing_numbers)
use a function which returns a number: FIND("world", "hello everybody")

See also