已有 1045 次閱讀2008-4-15 12:52 |個(gè)人分類:sum函數(shù)應(yīng)用
課題:用sum計(jì)算 1+1/2+1/4+1/6…..1/50的值.
颶風(fēng) 方法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}
涂鴉板
評(píng)論
|站長(zhǎng)郵箱|小黑屋|手機(jī)版|Office中國(guó)/Access中國(guó) ( 粵ICP備10043721號(hào)-1 )
GMT+8, 2024-10-23 08:28 , Processed in 0.087519 second(s), 14 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.