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.