📄 worksheetfunction.html
字号:
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#amorlinc(double, java.lang.String, java.lang.String, double, double, double, double)">amorlinc</A></B>(double cost,
java.lang.String date_purchased,
java.lang.String first_period,
double salvage,
double period,
double rate,
double basis)</CODE>
<BR>
返回每个结算期间的折旧值，该函数为法国会计系统提供。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#and(application.workbooks.workbook.worksheets.worksheet.Range)">and</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range)</CODE>
<BR>
所有参数的逻辑值为真时，返回 TRUE；只要一个参数的逻辑值为假，即返回 FALSE。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#areas(application.workbooks.workbook.worksheets.worksheet.Range)">areas</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> reference)</CODE>
<BR>
返回包含在引用中的单元格区域个数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#asc(java.lang.String)">asc</A></B>(java.lang.String string)</CODE>
<BR>
将字符串中的全角（双字节）英文字母或数字更改为半角（单字节）字符。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#asin(double)">asin</A></B>(double number)</CODE>
<BR>
返回指定数值的反正弦值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#asinh(double)">asinh</A></B>(double number)</CODE>
<BR>
求反双曲正弦值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#atan(double)">atan</A></B>(double number)</CODE>
<BR>
返回指定数字的绝对值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#atan2(double, double)">atan2</A></B>(double X_num,
double Y_num)</CODE>
<BR>
求给定X，Y坐标的反正切值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#atanh(double)">atanh</A></B>(double number)</CODE>
<BR>
求反双曲正切值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#avedev(application.workbooks.workbook.worksheets.worksheet.Range)">avedev</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range)</CODE>
<BR>
用于评测这组数据的离散度。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#average(application.workbooks.workbook.worksheets.worksheet.Range)">average</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range)</CODE>
<BR>
返回指定数据的平均值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#averagea(application.workbooks.workbook.worksheets.worksheet.Range)">averagea</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> values)</CODE>
<BR>
返回一组参数的算术平均值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#besseli(double, double)">besseli</A></B>(double x,
double n)</CODE>
<BR>
返回修正 Bessel 函数值，它与用纯虚数参数运算时的 Bessel 函数值相等, 该方法会去调用封装算法中的各方法，返回最终函数的结果。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#besselj(double, double)">besselj</A></B>(double x,
double n)</CODE>
<BR>
返回 Bessel 函数值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#besselk(double, int)">besselk</A></B>(double x,
int n)</CODE>
<BR>
返回修正 Bessel 函数值，它与纯虚数参数运算的 Bessel 函数值相等。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#bessely(double, int)">bessely</A></B>(double x,
int n)</CODE>
<BR>
返回 Bessel 函数值，也称为 Weber 函数或 Neumann 函数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#betadist(double, double, double, double, double)">betadist</A></B>(double x,
double alpha,
double beta,
double a,
double b)</CODE>
<BR>
返回 beta 累积分布函数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#betainv(double, double, double, double, double)">betainv</A></B>(double probability,
double alpha,
double beta,
double a,
double b)</CODE>
<BR>
返回 beta 累积分布函数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static long</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#bin2dec(long)">bin2dec</A></B>(long number)</CODE>
<BR>
将二进制数转化为十进制数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#bin2hex(long, int)">bin2hex</A></B>(long number,
int places)</CODE>
<BR>
将二进制数转化为十六进制数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#bin2oct(long, int)">bin2oct</A></B>(long number,
int places)</CODE>
<BR>
将二进制数转化为八进制数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#binomdist(double, double, double, boolean)">binomdist</A></B>(double number_s,
double trials,
double probability_s,
boolean cumulative)</CODE>
<BR>
一元二项式分布的概率值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#ceiling(double, double)">ceiling</A></B>(double number,
double significance)</CODE>
<BR>
求number向上舍入（延绝对值增大方向）接近的significance的倍数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#cell(java.lang.String, application.workbooks.workbook.worksheets.worksheet.Range)">cell</A></B>(java.lang.String info_type,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> reference)</CODE>
<BR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -