Function Product()

Product()

This function is used to calculate the product of values in the given range

Syntax:

= Product(Number1, Number2, Range1,.....)

Number1, Number2, Range1 = Number/Ranges for which the product is to be calculated

Example:

The function in the abovce image performs the multiplication of the numbers in the range C2:C6. The result of the function comes out to be 34,020.

Though I have rarely come across any spreadsheet that uses Product() function, but similar to Similar() function, this function is also more stable than using the multiplication sign (*).

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.