已有 1056 次阅读2008-4-15 12:52 |个人分类:sum函数应用
课题:用sum计算 1+1/2+1/4+1/6…..1/50的值.
飓风 方法1 {=1+SUM(1/(ROW(1:25)*2))}
小爪 方法2 {=SUM((ROW(1:50)/2=INT(ROW(1:50)/2))*(1/(ROW(1:50))))+1}
laoyebin 方法3 {=SUMPRODUCT(1/(ROW(1:25)*2))+1}
涂鸦板
评论
|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )
GMT+8, 2025-2-21 19:16 , Processed in 0.085971 second(s), 14 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.