Difference between revisions of "Manuals/calci/PRODUCTOF"
Jump to navigation
Jump to search
| (One intermediate revision by one other user not shown) | |||
| Line 6: | Line 6: | ||
==Description== | ==Description== | ||
*This function is showing product of the given set of numbers. | *This function is showing product of the given set of numbers. | ||
| − | *In <math>PRODUCTOF(TillNumber, StartNumber, | + | *In <math>PRODUCTOF(TillNumber, StartNumber,By)</math>, <math>TillNumber</math> is the final number in the product. |
*<math>StartNumber</math> is the starting number in the product. | *<math>StartNumber</math> is the starting number in the product. | ||
*<math>By</math> is the skip value in the product. | *<math>By</math> is the skip value in the product. | ||
| Line 20: | Line 20: | ||
#PRODUCTOF(12.3,5,3) = 440 | #PRODUCTOF(12.3,5,3) = 440 | ||
#PRODUCTOF(23.2,8.5,4) = 35939.0625 | #PRODUCTOF(23.2,8.5,4) = 35939.0625 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|xO_1bYgoQvA|280|center|PRODUCT}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 23:55, 13 February 2019
PRODUCTOF(TillNumber,StartNumber,By)
- is the final number.
- is the starting number.
- is the skip number.
is the final number.
is the starting number.
is the skip number.Description
- This function is showing product of the given set of numbers.
- In , is the final number in the product.
- is the starting number in the product.
- is the skip value in the product.
- A Product is a number or a quantity obtained by multiplying two or more numbers together.
- Here PRODUCTOF(10,4,2) = 1920.
- In this example it is doing the multiplication of 4*6*8*10=1920.
- Suppose the third parameter is not given,then the skip value is assigned as 1.
- So it is doing the multiplication of 4*5*6*7*8*9*10=604800.
, Examples
- PRODUCTOF(7,4) = 840
- PRODUCTOF(7,4,2) = 24
- PRODUCTOF(12.3,5,3) = 440
- PRODUCTOF(23.2,8.5,4) = 35939.0625
Related Videos
See Also
References