调试经验——Excel函数连乘函数（PRODUCT）的应用

 

问题：

 

解答：

 

其中，分子部分的计算使用了连乘函数PRODUCT。

 

Function Description

The Excel PRODUCT function returns the product (multiplication) of a supplied set of numerical values.

The syntax of the function is:

PRODUCT( number1, [number2], ... )

where the number arguments are a set of numbers (or arrays of numbers) that you want to calculate the product of.

In current versions of Excel (Excel 2007 and later), you can enter up to 255 number arguments to the Excel Product function, but in Excel 2003, the function will only accept up to 30 arguments. However, each argument can consist of an array of values or a range of cells, each of which can contain many values.

参考：

https://www.excelfunctions.net/excel-product-function.html