Excel函数用途.参数.用法速查表
时间:2023-10-10 03:24:07
(按Ctrl+F搜索)
一、数据库函数(13条) |
DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP GETPIVOTDATA |
二、日期与时间函数(20条) |
DATEDATEVaLUEDAYDAYS360EDATEEOMONTHHOURMINUTEMONTHNETWORKDAYSNOWSECONDTIMETIMEVaLUETODAYWEEKDAYWEEKNUMWORKDAYYEARYEARFRAC |
三、外部函数(2条) |
EUROCONVERTSQL.REQUEST |
四、工程函数(39条) |
BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTCOMPLEXCONVERTDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTMCONJUGATEIMCOSIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSINIMSQRTIMSUBIMSUMOCT2BINOCT2DECOCT2HEX |
五、财务函数(52条) |
ACCRINTACCRINTMAMORDEGRCAMORLINCCOUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNUMCOUPPCDCUMIPMTCUMPRINCDBDDBDISCDOLLARDEDOLLARFRDURATIONEFFECTFVFVSCHEDULEINTRATEIPMTIRRISPMTMDURATIONMIRRNOMINALNPERNPVODDFPRICEODDFYIELDODDLPRICEODDLYIELDPMTPPMTPRICEPRICEDISCPRICEMATPVRATERECEIVEDSLNSYDTBILLEQTBILLPRICETBILLYIELDVDBXIRRXNPVYIELDYIELDDISCYIELDMAT |
六、信息函数(9条) |
CELLERROR.TYPEINFOIS 类ISEVENISODDNNATYPE |
七、逻辑运算符(6条) |
ANDFALSEIFNOTORTRUE |
八、查找和引用函数(17条) |
ADDRESSAREASCHOOSECOLUMNCOLUMNSHLOOKUPHYPERLINKINDEXINDIRECTLOOKUPMATCHOFFSETROWROWSRTDTRANSPOSEVLOOKUP |
九、数学和三角函数(60条) |
ABSACOSACOSHASINASINHATANATAN2ATANHCEILINGCOMBINCOSCOSHCOUNTIFDEGREESEVENEXPFACTFACTDOUBLEFLOORGCDINTLCMLNLOGLOG10MDETERMMINVERSEMMULTMODMROUNDMULTINOMIALODDPIPOWERPRODUCTQUOTIENTRADIANSRANDRANDBETWEENROMANROUNDROUNDDOWNROUNDUPSERIESSUMSIGNSINSINHSQRTSQRTPISUBTOTALSUMSUMIFSUMPRODUCTSUMSQSUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC |
十、统计函数(80条) |
AVEDEVAVERAGEAVERAGEABETADISTBETAINVBINOMDISTCHIDISTCHIINVCHITESTCONFIDENCECORRELCOUNTCOUNTACOUNTBLANKCOUNTIFCOVARCRITBINOMDEVSQEXPONDISTFDISTFINVFISHERFISHERINVFORECASTFREQUENCYFTESTGAMMADISTGAMMAINVGAMMALNGEOMEANGROWTHHARMEANHYPGEOMDISTINTERCEPTKURTLARGELINESTLOGESTLOGINVLOGNORMDISTMAXMAXAMEDIANMINMINAMODENEGBINOMDISTNORMDISTNORMSINVNORMSDISTNORMSINVPEARSONPERCENTILEPERCENTRANKPERMUTPOISSONPROBQUARTILERANKRSQSKEWSLOPESMALLSTANDARDIZESTDEVSTDEVASTDEVPSTDEVPASTEYXTDISTTINVTRENDTRIMMEANTTESTVARVARAVARPVARPAWEIBULLZTEST |
十一、文本和数据函数(28条) |
ASCCHARCLEANCODECONCATENATEDOLLAR 或 RMBEXACTFINDFINDBFIXEDJISLEFT 或 LEFTBLEN 或 LENBLOWERMID 或 MIDBPHONETICPROPERREPLACE 或 REPLREPTRIGHT 或 RIGHTBSEARCH 或 SEARCSUBSTITUTETTEXTTRIMUPPERvalueWIDECHAR |
标签:Excel函数用途.参数.用法速查表
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
为word文档自动添加摘要
2023-03-10 08:31:53
电脑内存怎么升级_电脑内存升级方法
2022-08-27 01:48:39
![](https://img.aspxhome.com/file/2023/4/a303358_0s.jpg)
在 Mac 上管理 Hosts,现在有了更方便的工具:iHosts
2022-02-19 15:15:12
![](https://img.aspxhome.com/file/2023/2/a214202_0s.jpeg)
MS Excel 2016 如何为表格设置多个条件格式?-Excel教程
2022-02-24 07:17:33
wps表格怎么划斜线
2022-03-22 02:12:23
![](https://img.aspxhome.com/file/2023/5/a168785_0s.png)
如何在 iPhone 和 Mac 上关闭 Google 中的热门搜索?
2023-04-18 13:23:00
![](https://img.aspxhome.com/file/2023/9/a205519_0s.jpeg)
Win11怎么跳过微软账号登录?
2022-09-07 12:57:38
![](https://img.aspxhome.com/file/2023/27/a238065_0s.jpg)
Win7系统蓝屏提示drive power state failure的解决方法
2023-02-05 20:32:01
![](https://img.aspxhome.com/file/2023/3/a302741_0s.png)
蜻蜓FM怎么上传节目 蜻蜓FM上传节目方法
2023-06-25 09:41:39
![](https://img.aspxhome.com/file/2023/8/a338692_0s.jpg)
雷神911MR笔记本重装win11系统教程
2023-02-26 02:04:27
![](https://img.aspxhome.com/file/2023/30/a267599_0s.png)
Win7内存不能为read怎么办?Win7内存不能为read的解决方法
2023-04-19 19:00:57
![](https://img.aspxhome.com/file/2023/26/a228068_0s.png)
如何利用WPS下拉菜单批量录入数据
2022-10-06 10:58:12
![](https://img.aspxhome.com/file/2023/7/a164477_0s.png)
WPS2019怎么制作人物在墙壁后半隐的效果?
2023-03-26 01:23:31
![](https://img.aspxhome.com/file/2023/9/a166139_0s.jpg)
Win7电脑无线网络连接不见了怎么办?
2022-10-14 13:35:54
![](https://img.aspxhome.com/file/2023/26/a229156_0s.png)
金山wps怎么增加多张空白页
2023-11-30 15:25:55
![](https://img.aspxhome.com/file/2023/1/a164031_0s.jpg)
Windows 10,8.1中删除或忘记WiFi的未使用的网络名称
2022-07-28 09:03:25
![](https://img.aspxhome.com/file/2023/4/a305099_0s.jpg)
如何使用SnapMotion的手动模式?
2022-07-06 07:49:49
![](https://img.aspxhome.com/file/2023/5/a211735_0s.jpeg)
Win11系统怎么修改默认程序?默认程序修改步骤
2023-07-27 01:29:49
![](https://img.aspxhome.com/file/2023/1/a283600_0s.jpg)
EXCEL数据表怎么导入到SQLServer数据库中?
2023-12-10 08:47:41
![](https://img.aspxhome.com/file/2023/9/42329_0s.jpg)
wps表格行高怎么调整
2022-02-14 04:11:26