如何加總算出sigma(1到n)
在Excel如何*總算出 sigma ( 1 到 n),
不使用儲**,要能直接在儲**內輸 公式而得到*總值的. 例如: sigma(1,3)=6 *為 1+2+3 = 6 或 sigma(2,5)=14 *為 2+3+4+5 = 14 |
如何加總算出sigma(1到n)
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 |
All times are GMT +1. The time now is 11:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com