欢迎来到天天文库
浏览记录
ID:29219956
大小:411.50 KB
页数:69页
时间:2018-12-17
《EXCEL函数表(函数大全)》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、函数大全一、数据库函数(13条)DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDSUMDVARDVARPGETPIVOTDATA二、日期与时间函数(20条)DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHNETWORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC 三、外部函数(2条)EUROCONVERTSQL.REQUEST 四、工程函数(39
2、条)BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DEC OCT2HEX 五、财务函数(52条)·ACCRINT·
3、ACCRINTM·AMORDEGRC·AMORLINC·COUPDAYBS·COUPDAYS·COUPDAYSNC·COUPNUM·COUPPCD·CUMIPMT·CUMPRINC·DB·DDB·DISCDOLLARDE·DOLLARFR·DURATION·EFFECT·FV·FVSCHEDULE·INTRATE·IPMT·IRR·ISPMT·MDURATION·MIRR·NOMINAL·NPER·NPV·ODDFPRICE·ODDFYIELD·ODDLPRICE·ODDLYIELD·PMT·PPMT·PRICE·PRICEDISC·PRICEMA
4、T·PV·RATE·RECEIVED·SLN·SYD·TBILLEQ·TBILLPRICE·TBILLYIELD·VDB·XIRR·XNPV·YIELD·YIELDDISC·YIELDMAT六、信息函数(9条)·CELL·ERROR.TYPE·INFO·IS类·ISEVEN·ISODD·N·NA·TYPE七、逻辑运算符(6条)·AND·FALSE·IF·NOT·OR·TRUE八、查找和引用函数(17条)·ADDRESS·AREAS·CHOOSE·COLUMN·COLUMNS·HLOOKUP·HYPERLINK·INDEX·INDIRECT·LOOK
5、UP·MATCH·OFFSET·ROW·ROWS·RTD·TRANSPOSE·VLOOKUP九、数学和三角函数(60条)·ABS·ACOS·ACOSH·ASIN·ASINH·ATAN·ATAN2·ATANH·CEILING·COMBIN·COS·COSH·COUNTIF·DEGREES·EVEN·EXP·FACT·FACTDOUBLE·FLOOR·GCD·INT·LCM·LN·LOG·LOG10·MDETERM·MINVERSE·MMULT·MOD·MROUNDMULTINOMIAL·ODD·PI·POWER·PRODUCT·QUOTIENT·RA
6、DIANS·RAND·RANDBETWEEN·ROMAN·ROUND·ROUNDDOWN·ROUNDUP·SERIESSUM·SIGN·SIN·SINH·SQRT·SQRTPI·SUBTOTAL·SUM·SUMIF·SUMPRODUCT·SUMSQ·SUMX2MY2·SUMX2PY2·SUMXMY2·TAN·TANH·TRUNC十、统计函数(80条)·AVEDEV·AVERAGE·AVERAGEA·BETADIST·BETAINV·BINOMDIST·CHIDIST·CHIINV·CHITEST·CONFIDENCE·CORREL·COUNT·CO
7、UNTA·COUNTBLANK·COUNTIF·COVAR·CRITBINOM·DEVSQ·EXPONDIST·FDIST·FINV·FISHER·FISHERINV·FORECAST·FREQUENCY·FTEST·GAMMADIST·GAMMAINV·GAMMALN·GEOMEAN·GROWTH·HARMEAN·HYPGEOMDIST·INTERCEPT·KURT·LARGE·LINEST·LOGEST·LOGINV·LOGNORMDIST·MAX·MAXA·MEDIAN·MIN·MINA·MODE·NEGBINOMDIST·NORMDIST·
8、NORMSINV·NORMSDIST·NORMSINV·PEARSON·PERCENTILE·PERCENTRANK·PE
此文档下载收益归作者所有