Excel帮你选函数

旭日弘博 发表于 2010-6-22 09:31:00

<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"><SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">Excel<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">帮你选函数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体"> <SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">　　在用函数处理数据时，常常不知道使用什么函数比较合适。<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">Excel<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">的<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">搜索函数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">功能可以帮你缩小范围，挑选出合适的函数。<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体"> <SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">　　执行<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">插入<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'">→<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">函数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">命令，打开<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">插入函数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">对话框，在<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">搜索函数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">下面的方框中输入要求<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">(<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">如<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">计数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”)<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">，然后单击<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">转到<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">按钮，系统即刻将与<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">计数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">有关的函数挑选出来，并显示在<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">“<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">选择函数<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: Tahoma; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体">”<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">下面的列表框中。再结合查看相关的帮助文件，即可快速确定所需要的函数。
<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"><SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"> 
<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"><SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"> 
<SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma"><SPAN style="FONT-SIZE: 10pt; COLOR: #333333; FONT-FAMILY: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma">试一下吧  记得给我回复哦  呵呵谢谢

旭日弘博 发表于 2010-6-22 11:36:00

回复：Excel帮你选函数

呵呵谢谢希望能帮助大家

柳絮轻舞 发表于 2010-6-22 11:55:00

回复：Excel帮你选函数

谢谢楼主的分享~

92leehom 发表于 2010-6-22 14:29:00

回复: Excel帮你选函数

原帖由 旭日弘博 于 2010-6-22 11:36:00 发表 呵呵  谢谢  希望能帮助大家 
客气了哦~希望每天都能看到你的发言

sxed 发表于 2012-10-9 22:49:05

{:5_259:}哈哈，学习了。

cici可乐 发表于 2012-10-9 23:00:03

excel很好很强大，用好excel能为自己节省很多的时间，很喜欢这个工作工具。个人意见，不喜勿喷！

SIYECAO88 发表于 2014-3-7 15:24:01

不错，借鉴参考

1591403 发表于 2014-3-27 14:40:55

谢谢分享!

馨儿宝贝8 发表于 2014-5-22 09:13:54

学习

JS520WANGJUNXI 发表于 2014-5-22 15:44:30

谢谢楼主的分享

页: [1]

中人网's Archiver