6/394ExcelExcel函數(shù)語法匯錄目錄數(shù)學(xué)和三角函數(shù) 15ABS函數(shù) 15ACOS函數(shù) 15ACOSH函數(shù) 16AGGREGATE函數(shù) 16function_num函數(shù) 17ASIN函數(shù) 19ASINH函數(shù) 19ATAN函數(shù) 20ATAN2函數(shù) 20ATANH函數(shù) 21CEILING函數(shù) 22CEILING.PRECISE函數(shù) 22COMBIN函數(shù) 23COS函數(shù) 24COSH函數(shù) 24DEGREES函數(shù) 25EVEN函數(shù) 25EXP函數(shù) 26FACT函數(shù) 26FACTDOUBLE函數(shù) 27FLOOR函數(shù) 27FLOOR.PRECISE函數(shù) 28GCD函數(shù) 28INT函數(shù) 29LCM函數(shù) 30LN函數(shù) 30LOG函數(shù) 31LOG10函數(shù) 31MDETERM函數(shù) 32MINVERSE函數(shù) 32MMULT函數(shù) 33MOD函數(shù) 34MROUND函數(shù) 35MULTINOMIAL函數(shù) 35ODD函數(shù) 36PI函數(shù) 37POWER函數(shù) 37PRODUCT函數(shù) 38QUOTIENT函數(shù) 38RADIANS函數(shù) 39RAND函數(shù) 39RANDBETWEEN函數(shù) 40ROMAN函數(shù) 40ROUND函數(shù) 41ROUNDDOWN函數(shù) 42ROUNDUP函數(shù) 43SERIESSUM函數(shù) 43SIGN函數(shù) 44SIN函數(shù) 44SINH函數(shù) 45SQRT函數(shù) 45SQRTPI函數(shù) 46SUBTOTAL函數(shù) 46SUM函數(shù) 48SUMIF函數(shù) 49SUMIFS函數(shù) 50SUMPRODUCT函數(shù) 52SUMSQ函數(shù) 52SUMX2MY2函數(shù) 53SUMX2PY2函數(shù) 54SUMXMY2函數(shù) 54TAN函數(shù) 55TANH函數(shù) 56TRUNC函數(shù) 56統(tǒng)計(jì)函數(shù) 57AVEDEV函數(shù) 57AVERAGE函數(shù) 57AVERAGEA函數(shù) 59AVERAGEIF函數(shù) 60AVERAGEIFS函數(shù) 62BETA.DIST函數(shù) 63BETA.INV函數(shù) 64BINOM.DIST函數(shù) 65BINOM.INV函數(shù) 66CHISQ.DIST函數(shù) 66CHISQ.DIST.RT函數(shù) 67CHISQ.INV函數(shù) 68CHISQ.INV.RT函數(shù) 68CHISQ.TEST函數(shù) 69CONFIDENCE.NORM函數(shù) 70CONFIDENCE.T函數(shù) 71CORREL函數(shù) 71COUNT函數(shù) 72COUNTA函數(shù) 73COUNTBLANK函數(shù) 74COUNTIF函數(shù) 75COUNTIFS函數(shù) 76COVARIANCE.P函數(shù) 76COVARIANCE.S函數(shù) 77DEVSQ函數(shù) 78EXPON.DIST函數(shù) 78F.DIST函數(shù) 79F.DIST.RT函數(shù) 80F.INV函數(shù) 81F.INV.RT函數(shù) 81F.TEST函數(shù) 82FISHER函數(shù) 83FISHERINV函數(shù) 83FORECAST函數(shù) 84FREQUENCY函數(shù) 85GAMMA.DIST函數(shù) 86GAMMA.INV函數(shù) 86GAMMALN函數(shù) 87GEOMEAN函數(shù) 88GROWTH函數(shù) 89HARMEAN函數(shù) 90HYPGEOM.DIST函數(shù) 91INTERCEPT函數(shù) 92KURT函數(shù) 93LARGE函數(shù) 94LINEST函數(shù) 95LOGEST函數(shù) 99LOGNORM.DIST函數(shù) 102LOGNORM.INV函數(shù) 102MAX函數(shù) 103MAXA函數(shù) 104MEDIAN函數(shù) 105MIN函數(shù) 106MINA函數(shù) 106MODE.MULT函數(shù) 107MODE.SNGL函數(shù) 108NEGBINOM.DIST函數(shù) 109NORM.DIST函數(shù) 110NORM.INV函數(shù) 110NORM.S.DIST函數(shù) 111NORM.S.INV函數(shù) 111PEARSON函數(shù) 112PERCENTILE.EXC函數(shù) 113PERCENTILE.INC函數(shù) 113PERCENTRANK.EXC函數(shù) 114PERCENTRANK.INC函數(shù) 114PERMUT函數(shù) 115POISSON.DIST函數(shù) 116PROB函數(shù) 117QUARTILE.EXC函數(shù) 117QUARTILE.INC函數(shù) 118RANK.AVG函數(shù) 119RANK.EQ函數(shù) 119RSQ函數(shù) 120SKEW函數(shù) 121SLOPE函數(shù) 122SMALL函數(shù) 123STANDARDIZE函數(shù) 124STDEV.P函數(shù) 124STDEV.S函數(shù) 125STDEVA函數(shù) 126STDEVPA函數(shù) 127STEYX函數(shù) 128T.DIST函數(shù) 129T.DIST.2T函數(shù) 129T.DIST.RT函數(shù) 130T.INV函數(shù) 130T.INV.2T函數(shù) 131TREND函數(shù) 132TRIMMEAN函數(shù) 133T.TEST函數(shù) 134VAR.P函數(shù) 135VAR.S函數(shù) 135VARA函數(shù) 136VARPA函數(shù) 137WEIBULL.DIST函數(shù) 138Z.TEST函數(shù) 139時(shí)間和日期函數(shù) 140DATE函數(shù) 140DATEVALUE函數(shù) 141DAY函數(shù) 143DAYS360函數(shù) 143EDATE函數(shù) 145EOMONTH函數(shù) 145HOUR函數(shù) 146MINUTE函數(shù) 147MONTH函數(shù) 148NETWORKDAYS函數(shù) 148NETWORKDAYS.INTL函數(shù) 150NOW函數(shù) 151SECOND函數(shù) 152TIME函數(shù) 153TODAY函數(shù) 154WEEKDAY函數(shù) 155WEEKNUM函數(shù) 156WORKDAY函數(shù) 158WORKDAY.INTL函數(shù) 159YEAR函數(shù) 160YEARFRAC函數(shù) 161邏輯函數(shù) 162AND函數(shù) 162FALSE函數(shù) 163IF函數(shù) 164IFERROR函數(shù) 165NOT函數(shù) 166OR函數(shù) 167TRUE函數(shù) 167查找和引用函數(shù) 168ADDRESS函數(shù) 168AREAS函數(shù) 169CHOOSE函數(shù) 170COLUMN函數(shù) 171COLUMNS函數(shù) 172GETPIVOTDATA函數(shù) 172HLOOKUP函數(shù) 174HYPERLINK函數(shù) 175INDEX函數(shù) 177INDIRECT函數(shù) 178LOOKUP函數(shù) 179MATCH函數(shù) 181OFFSET函數(shù) 182ROW函數(shù) 183ROWS函數(shù) 184RTD函數(shù) 184VLOOKUP函數(shù) 185文本函數(shù) 187ASC函數(shù) 187BAHTTEXT函數(shù) 188CHAR函數(shù) 188CLEAN函數(shù) 189CODE函數(shù) 190CONCATENATE函數(shù) 190RMB函數(shù) 191EXACT函數(shù) 192FIND、FINDB函數(shù) 192FIXED函數(shù) 194JIS函數(shù) 195LEFT、LEFTB函數(shù) 195LEN、LENB函數(shù) 196LOWER函數(shù) 197MID、MIDB函數(shù) 198PHONETIC函數(shù) 199PROPER函數(shù) 199REPLACE、REPLACEB函數(shù) 200REPT函數(shù) 201RIGHT、RIGHTB函數(shù) 202SEARCH、SEARCHB函數(shù) 203SUBSTITUTE函數(shù) 204T函數(shù) 205TEXT函數(shù) 206TRIM函數(shù) 212UPPER函數(shù) 212VALUE函數(shù) 213財(cái)務(wù)函數(shù) 213ACCRINT函數(shù) 213ACCRINTM函數(shù) 215AMORDEGRC函數(shù) 216AMORLINC函數(shù) 218COUPDAYBS函數(shù) 219COUPDAYS函數(shù) 220COUPDAYSNC函數(shù) 222COUPNCD函數(shù) 223COUPNUM函數(shù) 225COUPPCD函數(shù) 226CUMIPMT函數(shù) 227CUMPRINC函數(shù) 228DB函數(shù) 229DDB函數(shù) 230DISC函數(shù) 231DOLLARDE函數(shù) 233DOLLARFR函數(shù) 233DURATION函數(shù) 234EFFECT函數(shù) 236FV函數(shù) 236FVSCHEDULE函數(shù) 237INTRATE函數(shù) 238IPMT函數(shù) 239IRR函數(shù) 240ISPMT函數(shù) 242MDURATION函數(shù) 242MIRR函數(shù) 244NOMINAL函數(shù) 245NPER函數(shù) 245NPV函數(shù) 246ODDFPRICE函數(shù) 247ODDFYIELD函數(shù) 250ODDLPRICE函數(shù) 251ODDLYIELD函數(shù) 253PMT函數(shù) 255PPMT函數(shù) 256PRICE函數(shù) 257PRICEDISC函數(shù) 258PRICEMAT函數(shù) 260PV函數(shù) 261RATE函數(shù) 263RECEIVED函數(shù) 264SLN函數(shù) 266SYD函數(shù) 266TBILLEQ函數(shù) 267TBILLPRICE函數(shù) 268TBILLYIELD函數(shù) 269VDB函數(shù) 270XIRR函數(shù) 271XNPV函數(shù) 273YIELD函數(shù) 274YIELDDISC函數(shù) 276YIELDMAT函數(shù) 277信息函數(shù) 279CELL函數(shù) 279ERROR.TYPE函數(shù) 281INFO函數(shù) 282IS函數(shù) 283IS函數(shù) 285IS函數(shù) 286IS函數(shù) 288IS函數(shù) 289IS函數(shù) 291IS函數(shù) 293IS函數(shù) 294ISODD函數(shù) 296IS函數(shù) 298N函數(shù) 300NA函數(shù) 301TYPE函數(shù) 301數(shù)據(jù)庫函數(shù) 302DAVERAGE函數(shù) 302DCOUNT函數(shù) 303DCOUNTA函數(shù) 305DGET函數(shù) 306DPRODUCT函數(shù) 307DSTDEV函數(shù) 308DSUM函數(shù) 309DVAR函數(shù) 310DVARP函數(shù) 312工程函數(shù) 313BESSELI函數(shù) 313BESSELJ函數(shù) 313BESSELK函數(shù) 314BESSELY函數(shù) 315BIN2DEC函數(shù) 315BIN2HEX函數(shù) 316BIN2OCT函數(shù) 317COMPLEX函數(shù) 318CONVERT函數(shù) 318DEC2BIN函數(shù) 322DEC2HEX函數(shù) 322DEC2OCT函數(shù) 323DELTA函數(shù) 324ERF函數(shù) 325ERF.PRECISE函數(shù) 326ERFC函數(shù) 326ERFC.PRECISE函數(shù) 327GESTEP函數(shù) 327HEX2BIN函數(shù) 328HEX2DEC函數(shù) 329HEX2OCT函數(shù) 329IMABS函數(shù) 330IMAGINARY函數(shù) 331IMARGUMENT函數(shù) 331IMCONJUGATE函數(shù) 332IMCOS函數(shù) 332IMDIV函數(shù) 333IMEXP函數(shù) 333IMLN函數(shù) 334IMLOG10函數(shù) 334IMLOG2函數(shù) 335IMPOWER函數(shù) 335IMPRODUCT函數(shù) 336IMREAL函數(shù) 337IMSIN函數(shù) 337IMSQRT函數(shù) 338IMSUB函數(shù) 338IMSUM函數(shù) 339OCT2BIN函數(shù) 339OCT2DEC函數(shù) 340OCT2HEX函數(shù) 341兼容性函數(shù) 342BETADIST函數(shù) 342BETAINV函數(shù) 342BINOMDIST函數(shù) 343CHIDIST函數(shù) 345CHIINV函數(shù) 345CHITEST函數(shù) 346CONFIDENCE函數(shù) 347COVAR函數(shù) 349CRITBINOM函數(shù) 349EXPONDIST函數(shù) 350FDIST函數(shù) 351FINV函數(shù) 352FTEST函數(shù) 353GAMMADIST函數(shù) 354GAMMAINV函數(shù) 355HYPGEOMDIST函數(shù) 356LOGNORMDIST函數(shù) 357MODE函數(shù) 358NEGBINOMDIST函數(shù) 359NORMDIST函數(shù) 360NORMINV函數(shù) 361NORMSDIST函數(shù) 362NORMSINV函數(shù) 362PERCENTILE函數(shù) 363PERCENTRANK函數(shù) 364POISSON函數(shù) 365QUARTILE函數(shù) 366RANK函數(shù) 367STDEV函數(shù) 368STDEVP函數(shù) 369TDIST函數(shù) 370TINV函數(shù) PAGEREF_To