Posts

PRODUCT function

6 commentsยท0 reblogs
excelsheets
51
0 views
ยท
1 min read

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:** ![](https://images.ecency.com/DQmZ5N9qa4C68WWj5aC43KaLdRYWinuuU5bs1qHoXdYzMxH/image.png)
**Product of values in a column:** ![](https://images.ecency.com/DQmYx4TLav3jXenZCVcBB1CHEkNg9f5NTiYDtdhdXWn9m2z/image.png)
**Product of values of non-contiguous cells:** ![](https://images.ecency.com/DQmRrntSg4pBTb57rRp3gLo6mczinyLycaRRQZf38VLpYcN/image.png)

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.