Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 5105|回复: 19

[习题] 常用函数名

  [复制链接]
发表于 2010-12-13 18:30 | 显示全部楼层 |阅读模式
<table class="MsoNormalTable" cellspacing="1" cellpadding="0" width="105%" align="left" border="1" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BACKGROUND: #999999; MARGIN: auto 6.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 105.32%; BORDER-BOTTOM: windowtext 1pt solid; mso-cellspacing: .7pt; mso-border-alt: solid windowtext .5pt; mso-table-lspace: 9.0pt; mso-table-rspace: 9.0pt; mso-table-anchor-vertical: margin; mso-table-anchor-horizontal: margin; mso-table-left: left; mso-table-top: 23.3pt; mso-padding-alt: 3.75pt 3.75pt 3.75pt 3.75pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;"><tbody><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><b><span style="COLOR: #990000; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">函数名</span></b><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><b><span style="COLOR: #990000; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">功能</span></b><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 1;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">ABS</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">求出参数的绝对值。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 2;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_1.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">AND</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_1.shtml" target="_blank"><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">“</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">与</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">”</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">运算,返回逻辑值,仅当有参数的结果均为逻辑</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">“</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">真(</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">TRUE</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">)</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">”</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">时返回逻辑</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">“</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">真(</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">TRUE</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">)</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">”</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">,反之返回逻辑</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">“</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">假(</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">FALSE</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">)</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">”</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 3;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_2.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">AVERAGE</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_2.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">求出所有参数的算术平均值。</span></span><span lang="EN-US" style="COLOR: black; TEXT-DECORATION: none; text-underline: none;"><span lang="EN-US">
                                                                        </span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 4;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_3.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">COLUMN</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_3.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">显示所引用单元格的列标号值。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 5;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_4.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">CONCATENATE</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_4.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">将多个字符文本或单元格中的数据连接在一起,显示在一个单元格中。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 6;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_5.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">COUNTIF</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_5.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">统计某个单元格区域中符合指定条件的单元格数目。</span></span><span lang="EN-US" style="COLOR: black; TEXT-DECORATION: none; text-underline: none;"><span lang="EN-US">
                                                                        </span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 7;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_6.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">DATE</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753577_6.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">给出指定数值的日期。</span></span><span lang="EN-US" style="COLOR: black; TEXT-DECORATION: none; text-underline: none;"><span lang="EN-US">
                                                                        </span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 8;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">DATEDIF</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">计算返回两个日期参数的差值。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 9;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_1.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">DAY</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_1.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">计算参数中指定日期或引用单元格中的日期天数。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 10;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_2.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">DCOUNT</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_2.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">返回数据库或列表的列中满足指定条件并且包含数字的单元格数目。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 11;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_3.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">FREQUENCY</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_3.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">以一列垂直数组返回某个区域中数据的频率分布。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 12;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_4.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">IF</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_4.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">根据对指定条件的逻辑判断的真假结果,返回相对应条件触发的计算结果。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 13;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_5.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">INDEX</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_5.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">返回列表或数组中的元素值,此元素由行序号和列序号的索引值进行确定。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 10.25pt; mso-yfti-irow: 14;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 10.25pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_6.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">INT</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 10.25pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753580_6.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">将数值向下取整为最接近的整数。</span></span><span lang="EN-US" style="COLOR: black; TEXT-DECORATION: none; text-underline: none;"><span lang="EN-US">
                                                                        </span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 15;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">ISERROR</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">用于测试函数式返回的数值是否有错。如果有错,该函数返回</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">TRUE</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">,反之返回</span></span><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">FALSE</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 16;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_1.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">LEFT</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_1.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">从一个文本字符串的第一个字符开始,截取指定数目的字符。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 17;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_2.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">LEN</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_2.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">统计文本字符串中字符数目。</span></span><span lang="EN-US" style="COLOR: black; TEXT-DECORATION: none; text-underline: none;"><span lang="EN-US">
                                                                        </span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 18;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_3.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">MATCH</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_3.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">返回在指定方式下与指定数值匹配的数组中元素的相应位置。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 19;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_4.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">MAX</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_4.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">求出一组数中的最大值。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 20;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_5.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">MID</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_5.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">从一个文本字符串的指定位置开始,截取指定数目的字符。</span></span><span lang="EN-US" style="COLOR: black; TEXT-DECORATION: none; text-underline: none;"><span lang="EN-US">
                                                                        </span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 21;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_6.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">MIN</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753581_6.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">求<span lang="EN-US">出一组数中的最小值。</span></span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 22;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753583.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">MOD</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753583.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">求出两数相除的余数。</span></span></a><p></p></span></p></td></tr><tr style="HEIGHT: 9.8pt; mso-yfti-irow: 23; mso-yfti-lastrow: yes;"><td width="19%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 19.42%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753583_1.shtml" target="_blank"><b><span style="COLOR: black; TEXT-DECORATION: none; text-underline: none;">MONTH</span></b></a><p></p></span></p></td><td width="66%" style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 3.75pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 3.75pt; BACKGROUND: #f9f9f9; PADDING-BOTTOM: 3.75pt; BORDER-LEFT: windowtext 1pt solid; WIDTH: 66.86%; PADDING-TOP: 3.75pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 9.8pt; mso-border-alt: solid windowtext .5pt;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan; mso-element: frame; mso-element-frame-hspace: 9.0pt; mso-element-wrap: around; mso-element-anchor-horizontal: margin; mso-element-top: 23.3pt; mso-height-rule: exactly;"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: Tahoma; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt;"><a href="http://www.yesky.com/SoftChannel/72357786515668992/20031215/1753583_1.shtml" target="_blank"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; TEXT-DECORATION: none; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; text-underline: none;"><span lang="EN-US">求出指定日期或引用单元格中的日期的月份。</span></span></a><p></p></span></p></td></tr></tbody></table>

评分

参与人数 1 +3 收起 理由
梅一枝 + 3

查看全部评分

excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
发表于 2010-12-13 18:31 | 显示全部楼层
回复

使用道具 举报

发表于 2010-12-13 18:35 | 显示全部楼层
回复

使用道具 举报

发表于 2010-12-13 18:52 | 显示全部楼层

学习了[em02][em01]
回复

使用道具 举报

发表于 2010-12-15 14:02 | 显示全部楼层

[em01]
回复

使用道具 举报

发表于 2011-1-14 15:56 | 显示全部楼层
{:35:}  学习了。
回复

使用道具 举报

发表于 2011-1-14 16:57 | 显示全部楼层
谢谢楼主分享
回复

使用道具 举报

发表于 2011-1-14 17:02 | 显示全部楼层
学习一下
回复

使用道具 举报

发表于 2011-1-14 17:09 | 显示全部楼层
学习一下
回复

使用道具 举报

发表于 2011-1-14 17:13 | 显示全部楼层
学习了
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-16 06:39 , Processed in 0.311200 second(s), 11 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表