PRODUCT Function (Functions in Excel)
Numbers | Product | ||
2 | 3 | 6 | =PRODUCT(C4,D4) |
5 | 10 | 50 | =PRODUCT(C5:D5) |
3 | 7 | 210 | =PRODUCT(C6:D6,10) |
6300 | =PRODUCT(C4:D6) | ||
What Does It Do ? |
This function multiples a group of numbers together. |
It is the same as using 2*3*5*10*3*7, which results in 6300. |
Syntax |
=PRODUCT(Number1,Number2,Number3... through to Number30) |
or |
=PRODUCT(RangeOfNumbers) |
or |
=PRODUCT(Number1,Range,Number2...) |
Formatting |
No special formatting is needed. |
0 comments:
Post a Comment