首页
云表平台
品牌
客户案例
管理智库
用户故事
新闻动态
管理系统
应用商城
云粉社区
新手指南
视频教程
学习教程
帮助文档
视频教程
收费课堂
亲,请
登录
|
免费注册
|
管理控制台
查看“单元格公式的函数”的源代码
←
单元格公式的函数
跳转至:
导航
、
搜索
因为以下原因,你没有权限编辑本页:
您刚才请求的操作只对以下1个用户组开放:
用户
。
您可以查看并复制此页面的源代码:
<center><h1>填表公式函数</h1></center> <TABLE FRAME=VOID CELLSPACING=0 COLS=7 RULES=NONE BORDER=0> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=80 HEIGHT=48 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">序号</FONT></B></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=147 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">函数</FONT></B></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=239 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">用法</FONT></B></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=269 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">示例</FONT></B></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=147 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">单元格支持</FONT></B></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=147 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">填表公式支持</FONT></B></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" WIDTH=658 ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#C0C0C0"><B><FONT FACE="Tahoma" SIZE=4 COLOR="#000000">用途</FONT></B></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="1" SDNUM="1033;">1</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ABS</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ABS(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ABS(-0.5)=0.5</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一参数的绝对值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="2" SDNUM="1033;">2</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ACOSH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ACOSH(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ACOSH(1)=0</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回参数的反双曲余弦值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=20 ALIGN=CENTER VALIGN=MIDDLE SDVAL="3" SDNUM="1033;">3</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">AND</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000"> AND(条件1,条件2)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">AND(1+1<2,1<3)=FALSE</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">与。AND之内的所有条件都为真是,AND的结果才为真。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="4" SDNUM="1033;">4</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ASINH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ASINH(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ASINH(10)=2.99822295029797</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回参数的反双曲正弦值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="5" SDNUM="1033;">5</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ATAN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ATAN(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ATAN(1)*180/PI()=45°</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回参数的反正切值。返回的数值以弧度表示,大小在-π/2~π/2之间。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=38 ALIGN=CENTER VALIGN=MIDDLE SDVAL="6" SDNUM="1033;">6</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ATANH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ATANH(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ATANH(0.76159416)=1.00000000962972</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回参数的反双曲正切值,参数必须在-1~1之间(不包括-1和1)。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="7" SDNUM="1033;">7</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">AVERAGE</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">AVERAGE(数值,数值,...)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">AVERAGE(1,2,3)=2</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:计算所有参数的算术平均值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=38 ALIGN=CENTER VALIGN=MIDDLE SDVAL="8" SDNUM="1033;">8</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">CEILING</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">CEILING(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">CEILING(3.141596,0.1)=3.2</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:将参数Number沿绝对值增大的方向,返回一个最接近的整数或基数significance的最小倍数。如CEILING(3.1415,2)=4表示将3.1415沿着2,4,6,8...的方向选取最最近3.1415的值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="9" SDNUM="1033;">9</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COLUMN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">COLUMN(单元格)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COLUMN(D10)=4</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#33CCCC"><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">×</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回给定引用的列标。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="10" SDNUM="1033;">10</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COS</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">COS(弧度)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COS(RADIANS(60))=0.5</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一角度的余弦值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="11" SDNUM="1033;">11</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COSH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">COSH(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COS(0)=1</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回参数的双曲余弦值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="12" SDNUM="1033;">12</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COUNT</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">COUNT(单元格区域)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COUNT(A2:D5)=4</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#33CCCC"><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">×</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回数字参数的个数。它可以统计数组或单元格区域中含有数字的单元格个数。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="13" SDNUM="1033;">13</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COUNTA</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">COUNTA(单元格区域)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">COUNTA(B2:D5)=8</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#33CCCC"><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">×</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回参数组中非空值的数目。利用函数COUNTA可以计算数组或单元格区域中数据项的个数。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="14" SDNUM="1033;">14</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">DATE</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">DATE(日期)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">DATE(2014,8,10)=2014'年'8'月'10'日'</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回代表特定日期的序列号。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=56 ALIGN=CENTER VALIGN=MIDDLE SDVAL="15" SDNUM="1033;">15</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">DAY</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">DAY(日期)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">DAY(2014/08/10)=9</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回用序列号(整数1到31)表示的某日期的天数,用整数1到31表示。在单元格中使用的时候,需要引用格式为日期的其他单元格。如DAY(D2),D2单元格为日期类型。的在填表公式使用的时候,需要设置字段的数据类型为整数,单元格类型为常规。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=38 ALIGN=CENTER VALIGN=MIDDLE SDVAL="16" SDNUM="1033;">16</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">DEGREES</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">DEGREES(弧度)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">DEGREES(3.141592654)=180.000000023503</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:将弧度转换为度。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=40 ALIGN=CENTER VALIGN=MIDDLE SDVAL="17" SDNUM="1033;">17</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">FIND</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">FIND(大字符串,小字符串,查找的起始位置)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">FIND("ab","goabcabd",5)=6</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:FIND用于查找其他文本串(within_text)内的文本串(find_text),并从within_text的首字符开始返回find_text的起始位置编号。此函数适用于双字节字符,它区分大小写但不允许使用通配符。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="18" SDNUM="1033;">18</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">INT</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">INT(小数)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">INT(35.501)=35</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:将任意实数向下取整为最接近的整数。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="19" SDNUM="1033;">19</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">LEN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">LEN(字符串)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">LEN("abc")=3</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:LEN返回文本串的字符数。LENB返回文本串中所有字符的字节数。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="20" SDNUM="1033;">20</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">LOG10</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">LOG10(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">LOG10(100)=2</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回以10为底的对数。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="21" SDNUM="1033;">21</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">MAX</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">MAX(数值,数值,...)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">MAX(3,5,7)=7</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回数据集中的最大数值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="22" SDNUM="1033;">22</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">MIN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">MIN(数值,数值,...)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">MIN(3,5,7)=3</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回给定参数表中的最小值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=56 ALIGN=CENTER VALIGN=MIDDLE SDVAL="23" SDNUM="1033;">23</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">MONTH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">MONTH(日期)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">MONTH(2014-08-2)=8</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回以序列号表示的日期中的月份,它是介于1(一月)和12(十二月)之间的整数。在单元格中使用的时候,需要引用格式为日期的其他单元格。如MONTH(D2),D2单元格为日期类型。的在填表公式使用的时候,需要设置字段的数据类型为整数,单元格类型为常规。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=20 ALIGN=CENTER VALIGN=MIDDLE SDVAL="24" SDNUM="1033;">24</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">NOW</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">NOW()</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">NOW()=2014-8-1 9:59</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回当前日期和时间所对应的序列号。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="25" SDNUM="1033;">25</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">OR</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">OR(条件,条件,...)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">OR(1+1=3,3>1)=TRUE</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">或。只要OR之内的条件有一个为真,那么OR的结果就为真。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="26" SDNUM="1033;">26</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">PI</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">PI()</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">2*PI()*PI()=19.7392088021787</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回圆周率π,精确到小数点后14位。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="27" SDNUM="1033;">27</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">POWER</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">POWER(基数,幂)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">POWER(2,3)=8</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回给定数字的乘幂。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="28" SDNUM="1033;">28</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RADIANS</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">RADIANS(角度)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RADIANS(360)=6.28318530717959</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:将一个表示角度的数值或参数转换为弧度。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="29" SDNUM="1033;">29</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">REPT</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">REPT(字符串,重复次数)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">REPT("ruby,",3)=ruby,ruby,ruby</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:按照给定的次数重复显示文本。可以通过REPT函数对单元格进行重复填充。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="30" SDNUM="1033;">30</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE>RMB</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">RMB(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">RMB(16.69)=壹拾陆元陆角玖分</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=TOP><FONT FACE="Tahoma" SIZE=2 COLOR="#333333">用途:例如单元格A1=总金额,B1要显示总金额的大写,B1=RMB(A1)</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="31" SDNUM="1033;">31</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROW</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ROW(单元格)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROW(D36)=36</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#33CCCC"><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">×</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回给定引用的行号。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="32" SDNUM="1033;">32</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROUND</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ROUND(小数)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROUND(3.141596,3)=3.142</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:按指定位数四舍五入某个数字。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="33" SDNUM="1033;">33</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROUNDDOWN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ROUNDDOWN(小数)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROUNDDOWN(3.141596,3)=3.141</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:按绝对值减小的方向舍入某一数字。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="34" SDNUM="1033;">34</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROUNDUP</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">ROUNDUP(小数)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">ROUNDUP(3.141596,3)=3.142</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:按绝对值增大的方向舍入一个数字。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=40 ALIGN=CENTER VALIGN=MIDDLE SDVAL="35" SDNUM="1033;">35</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=TOP><FONT FACE="Tahoma" SIZE=2 COLOR="#333333">SEGMENT</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">SEGMENT(文本,分隔符,子字符串的位置)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">segment("12*30*50","*",2)=30</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#33CCCC"><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">×</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma">用途: 1、假设单元格A1的内容为12*30*One, 要取出12和One让他们相链接成一个新的字符串12One,那么单元格A2的内容应为segment(A1,"*",1)+segment(A1,"*",3) </FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="36" SDNUM="1033;">36</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SIGN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">SING(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SIGN(-3)=-1</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回数字的符号。正数返回1,零返回0,负数时返回-1。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="37" SDNUM="1033;">37</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SIN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">SIN(弧度)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SIN(RADIANS(30))=0.5</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一角度的正弦值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=38 ALIGN=CENTER VALIGN=MIDDLE SDVAL="38" SDNUM="1033;">38</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SINH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">SINH(弧度)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SINH(RADIANS(30))=0.54785347388804</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回任意实数的双曲正弦值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="39" SDNUM="1033;">39</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">STDEV</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">STDEV(数值,数值,...)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">STDEV(1,3,5)=2</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:估算样本的标准偏差。它反映了数据相对于平均值(mean)的离散程度。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="40" SDNUM="1033;">40</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SQRT</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">SQRT(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SQRT(9)=3</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一正数的算术平方根。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="41" SDNUM="1033;">41</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SUM</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">SUM(数值,数值,...)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">SUM(1,2,3,4,5)=15</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE BGCOLOR="#33CCCC"><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">×</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一单元格区域中所有数字之和。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="42" SDNUM="1033;">42</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TAN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">TAN(弧度)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TAN(RADIANS(45))=1</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一角度的正切值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="43" SDNUM="1033;">43</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TANH</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">TANH(数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TANH(0.5)=0.46211715726001</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回任意实数的双曲正切值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=38 ALIGN=CENTER VALIGN=MIDDLE SDVAL="44" SDNUM="1033;">44</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TIME</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">TIME(时,分,秒)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TIME(11,30,45)=0.4796875</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某一特定时间的小数值,它返回的小数值从0到0.99999999之间,代表0:00:00(12:00:00A.M)到23:59:59(11:59:59P.M)之间的时间。注意设置单元格的格式为常规或数值。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=20 ALIGN=CENTER VALIGN=MIDDLE SDVAL="45" SDNUM="1033;">45</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TODAY</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TODAY()</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">TODAY()=2014/8/1</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回系统当前日期的序列号。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=56 ALIGN=CENTER VALIGN=MIDDLE SDVAL="46" SDNUM="1033;">46</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">YEAR</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">YEAR(日期)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">YEAR(2014-08-01)=2014</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回某日期的年份。其结果为1900到9999之间的一个整数。在单元格中使用的时候,需要引用格式为日期的其他单元格。如YEAR(D2),D2单元格为日期类型。的在填表公式使用的时候,需要设置字段的数据类型为整数,单元格类型为常规。</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=20 ALIGN=CENTER VALIGN=MIDDLE SDVAL="47" SDNUM="1033;">47</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RAND</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RAND()</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RAND()</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回一个随机数</FONT></TD> </TR> <TR> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" HEIGHT=21 ALIGN=CENTER VALIGN=MIDDLE SDVAL="48" SDNUM="1033;">48</TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RANDBETWEEN</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">RANDBETWEEN(数值,数值)</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Ђˎ̥" SIZE=2 COLOR="#000000">RANDBETWEEN(80,100)=93</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=CENTER VALIGN=MIDDLE><FONT FACE="Arial" SIZE=2 COLOR="#000000">√</FONT></TD> <TD STYLE="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" ALIGN=LEFT VALIGN=MIDDLE><FONT FACE="Tahoma" SIZE=2 COLOR="#000000">用途:返回指定范围内的随机数</FONT></TD> </TR> </TABLE>
返回
单元格公式的函数
。
导航菜单
查看
阅读
查看源代码
查看历史
操作
搜索
名字空间
页面
讨论
变种
首页
云表平台简介
云表概述
云表服务器各版本介绍
安装与配置
概述
创建云端应用空间
创建本地应用空间
安装云表服务器
商城产品的购买与安装
解绑服务器
激活服务器
在其它电脑上安装云表浏览器
新手入门
登入系统
新建文件夹
新建模板
如何定义数据项
在总表中管理表单
定义明细表
简化和规范数据的录入
列表选择辅助表单填写
设置主键,保证数据的唯一性
Excel公式快速填写表单
根据表单数据自动填写其它数据
在对话框中添加按钮
用本表单更改其它表单信息
使用数据校验保证准确性
组织机构
设置表单的操作权限
设置允许查看的数据范围
建立统计报表方便数据的查询
简易工作流的使用
建立业务流程
建立导航,美化系统
文件夹与导航目录
1.1 文件夹
表单模板
2.1 概述
2.2 新建模板
2.3 多表格模板的设计
2.4 内嵌浏览器的设计
2.5 模板样式
2.6 基本数据项
2.7 明细表
2.8 树形明细
2.9 交叉表
2.10 数据表管理
2.11 单元格格式
2.12 单元格类型
2.13 云表浏览器内核的切换方法
2.14 工具栏按钮右键菜单设置
2.15 隐藏文件列表操作按钮
数据接口
3.1 概述
3.2 自动编号
3.3 下拉列表
3.4 列表选择
3.5 树形列表
3.6 系统变量
状态设置
4.1 概述
4.2 应用
模板属性
5.1 基本属性
5.2 锁定条件
5.3 审批流程
5.4 附件
组织机构与操作权限
6.1 角色
6.2 用户
6.3 组织机构
6.4 岗位
6.5 业务公式更新用户信息
模板权限
7.1 权限
7.2 策略
总表
8.1 概述
8.2 筛选
8.3 分页显示
8.4 设置列宽
8.5 设置隐藏/显示数据项
8.6 设置数据项显示顺序
8.7 恢复列默认设置
8.8 显示表单图片
8.9 批量审核
8.10 批量导入
8.11 批量导入图片
8.12 给总表添加分类树
8.13 在总表中显示明细表
8.14 在总表中关联显示其他表单
填表公式
9.1 概述
9.2 事件
9.3 数据源
9.4 操作
9.5 函数
9.6 应用
业务公式
10.1 概述
10.2 快速入门
10.3 参数说明
10.4 新建操作
10.5 更新操作
10.6 删除操作
10.7 报错操作
10.8 更新明细表
10.9 子数据源
10.10 原理讲解
10.11 深入理解业务公式
10.12 事件
10.13 业务公式更新用户信息
业务流程
11.1 概述
11.2 快速入门
11.3 工作流进阶
11.4 流程删除方法
11.5 系统变量使用方法
其他类型模板
12.1 统计查询
12.2 报表
12.3 图表
12.4 设计登入界面
图形表单(导航)
13.1 使用方法
13.2 实现九宫格布局
系统服务
14.1 短信服务
14.2 短信服务(旧)
14.3 邮件服务
14.4 计划任务
14.5 系统日志
14.6 电话盒子服务
14.7 APP消息推送服务
14.8 文件系统
14.9 对接企业微信配置
14.10 对接钉钉配置
14.11 企业微信推送配置
14.12 微信推送配置
14.13 钉钉推送配置
14.14 网关服务器配置方法
系统配置
15.1 全局边栏配置
15.2 全局超时时间配置
企业云盘
16.1 概述
16.2 个人文件夹
16.3 协作文件夹
16.4 公用文件夹
16.5 基本操作
16.6 表单与云盘配合使用
外部数据源
17.1 概述
17.2 新建数据源(数据库)
17.3 新建数据源(API)
表达式
18.1 执行表达式
18.2 赋值表达式
打印
19.1 打印设置
19.2 自定义纸张大小
19.3 默认打印机设置
19.4 批量打印条码标签
移动端APP
20.1 APP概述
20.2 APP下载及安装
20.3 APP使用说明
20.4 APP地图定位
20.5 APP自动分组
云表服务器控制中心
21.1 云表服务器控制中心使用说明
常见问题分析
22.1 启动服务失败问题汇总
22.2 手工安装加密锁驱动
22.3 常用端口
22.4 配置数据接口最大返回条数限制
22.5 服务器安装启动问题指南
通用
23.1 函数
23.2 隐藏待办事项和已完成事项设置方法
23.3 账号密码缓存管理
23.4 修改模板样式文件及附件文件保存路径
23.5 导出word文档使用方法
23.6 电子围栏的使用
23.7 Json数据接口
23.8 高拍仪的使用
23.9 身份证读卡器的使用
23.10 同步组织机构
23.11 云表支付功能开通流程
23.12 云表支付业务逻辑设计
23.13 OpenAPI接口使用说明
管理软件帮助文档
云表进销存操作说明
新版帮助
表单与模版:概述
统计查询:概述
统计查询:区别
统计查询:基本用法
工具
链入页面
相关更改
特殊页面
页面信息