在Excel如何åŠ*總算出 sigma ( 1 到 n),
ä¸�使用儲å*˜æ*¼,è¦�能直接在儲å*˜æ*¼å…§è¼¸å …¥å…¬å¼�而得到åŠ*總值的.
例如:
sigma(1,3)=6 å›*為 1+2+3 = 6
或
sigma(2,5)=14 å›*為 2+3+4+5 = 14

I'm not sure what you mean by "åŠ*總", jefferson. In general the formula for 總和
i (m 到 n) ought to be

n(n+1)/2 - (m-1)m/2

....which comes out to

(n**2 - m**2 + m + n)/2

I'm not aware of any Excel function that does that calculation for you.

--- "jefferson" wrote:
在Excel如何åŠ*總算出 sigma (1 到 n),
ä¸�使用儲å*˜æ*¼,è¦�能直接在儲å*˜æ*¼å…§è¼¸å …¥å…¬å¼�而得到åŠ*總值的.
例如:
sigma(1,3)=6 å›*為 1+2+3 = 6
或
sigma(2,5)=14 å›*為 2+3+4+5 = 14