位置：首頁(yè) > 軟件操作教程 > 辦公軟件 > Excel > 問(wèn)題詳情

實(shí)用技巧：常規(guī)計(jì)算函數(shù)

提問(wèn)人：周麗平發(fā)布時(shí)間：2021-07-20

常規(guī)計(jì)算函數(shù)

函數(shù)名稱功能
SIGN函數(shù)返回?cái)?shù)字的符號(hào)
ABS函數(shù)計(jì)算數(shù)字的絕對(duì)值
SUM函數(shù)計(jì)算數(shù)字之和
PRODUCT函數(shù)計(jì)算數(shù)字之積
SQRT函數(shù)計(jì)算正平方根
MOD函數(shù)返回商的余數(shù)
QUOTIENT函數(shù)返回商的整數(shù)部分
GCD函數(shù)計(jì)算最大公約數(shù)
LCM函數(shù)計(jì)算最小公倍數(shù)
SUMIF函數(shù)按給定條件對(duì)指定單元格求和
SUMIFS函數(shù)按多個(gè)條件對(duì)指定單元格求和
SUMPRODUCT函數(shù)計(jì)算數(shù)組元素的乘積之和
SUMSQ函數(shù)計(jì)算參數(shù)的平方和
SUMXMY2函數(shù)計(jì)算數(shù)組對(duì)應(yīng)值之差的平方和
SUMX2MY2函數(shù)計(jì)算數(shù)組對(duì)應(yīng)值的平方差之和
SUMX2PY2函數(shù)計(jì)算數(shù)組對(duì)應(yīng)值的平方和之和
SERIESSUM函數(shù)計(jì)算基于公式的冪級(jí)數(shù)之和

繼續(xù)查找其他問(wèn)題的答案？

回復(fù)(0)
返回頂部