The Excel Product function
returns the product (multiplication) of a supplied set of numerical values.
The Product function
multiplies all the numbers given as arguments and returns the product.
For example, if cells A1 and
A2 contain numbers, you can use the formula =Product(A1, A2) to
multiply those two numbers together.
You can also perform the same
operation by using the multiply (*) mathematical operator; for example, =A1
* A2.
Syntax
The syntax for the Product function
in Microsoft Excel is:
=PRODUCT( number1, number2, ... number_n )
Parameters or Arguments
number1, number2, ... number_n
The numbers to multiply
together. There can be up to 30 numbers entered.
Excel Product Function Examples
The following spreadsheet
shows three simple examples of the Excel Product function:
Formulas:
|
|
A
|
B
|
|
1
|
3
|
=PRODUCT(
3, 6 )
|
|
2
|
2
|
=PRODUCT(
A1, A2 )
|
|
3
|
5
|
=PRODUCT(
A1:A3 )
|
Results:
|
The above example spreadsheet
shows that each argument to the Product function can be supplied as a single
value or cell reference, or as an array of values or cells.
Note
In current versions of Excel
(Excel 2007 and later), you can enter up to 255 number arguments to the Excel
Product function, but in Excel 2003, the function will only accept up to 30
arguments. However, each argument can consist of an array of values or a range
of cells, each of which can contain many values.
References
No comments:
Post a Comment