PRODUCT function

By @excelsheets11/27/2022excel

Another frequently used function in excel and gsheets is the PRODUCT function. It is the counterpart of the mathematical formula of multiplication.

Function Type: Math and Trigonometry

Description:
Multiplies its arguments. Mathematically, this is the function we use to multiply set of numbers in Excel or GSheets.

Function Structure:
=PRODUCT(number1, [number2]).

Argument Breakdown:
number1 - The first number or range to multiply.
[number2] - The second number or range to multiply. The square brackets wrapping the argument means this is optional. The function can work with just 1 argument.

Examples:
Product of constant number values:


**Product of values in a range:**
**Product of values in a column:**
**Product of values of non-contiguous cells:**

Still need help with Excel and Google Sheets?
Get Instant Expert Help
We can also accept LEO, HIVE, HBD tokens as payment.


This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 😉

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva.

34

comments