Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
如何加總算出sigma(1到n)
3,372 views
Skip to first unread message
jefferson
Sep 9, 2008, 11:55:04 AM9/9/08
to
在Excel如何加總算出 sigma ( 1 到 n),
不使用儲存格,要能直接在儲存格內輸入公式而得到加總值的.
例如:
sigma(1,3)=6 因為 1+2+3 = 6
或
sigma(2,5)=14 因為 2+3+4+5 = 14
不使用儲存格,要能直接在儲存格內輸入公式而得到加總值的.
例如:
sigma(1,3)=6 因為 1+2+3 = 6
或
sigma(2,5)=14 因為 2+3+4+5 = 14
Bob Bridges
Sep 12, 2008, 1:13:01 AM9/12/08
to
I'm not sure what you mean by "加總", jefferson. In general the formula for 總和
i (m 到 n) ought to be
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),
0 new messages