Recent

6/recent/ticker-posts

Header Ads Widget

product function in excel

The product function in excel gives result as product of given number provide as number. The product help us when we need to multily multiple cells together.

product function in excel

=PRODUCT(range)
eg
we have a 3 cell with value 2,6,5 now we need to calculate or multily 2*6*5 in this case we need to use PRODUCT function in excel


the purpose of this function is get the purdouct of supplied function
this function return the product of supplied number
Syntax
=PRODUCT(number1,number2,..........)
product function in excel

Number1 first number for calculate or cell references
number2,...= Continuous number till we need a product of the range
product function in excel


In this function, we can
-Supplied number individually
-can supply number in the range
- we can references only number
- empty cell are ignored by the product function

Post a Comment

0 Comments