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

## 0 comments:

## Post a Comment