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 Google Plus

About Rishie Khurana

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.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Sunday, May 24, 2009

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 (*).

Function Product()SocialTwist Tell-a-Friend

0 comments:

Post a Comment