📄 worksheetfunction.html
字号:
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#coupdaysnc(java.lang.String, java.lang.String, double, double)">coupdaysnc</A></B>(java.lang.String settlement,
java.lang.String maturity,
double frequency,
double basis)</CODE>
<BR>
返回从成交日到下一个付息日之间的天数。</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#coupncd(java.lang.String, java.lang.String, double, double)">coupncd</A></B>(java.lang.String settlement,
java.lang.String maturity,
double frequency,
double basis)</CODE>
<BR>
返回成交日后的下一个付息日期。</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#coupnum(java.lang.String, java.lang.String, int, int)">coupnum</A></B>(java.lang.String settlement,
java.lang.String maturity,
int frequency,
int basis)</CODE>
<BR>
返回成交日和到期日之间的付息次数，该值向上舍入到最近的整数。</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#couppcd(java.lang.String, java.lang.String, double, double)">couppcd</A></B>(java.lang.String settlement,
java.lang.String maturity,
double frequency,
double basis)</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#covar(double[], double[])">covar</A></B>(double[] array1,
double[] array2)</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#covar(application.workbooks.workbook.worksheets.worksheet.Range, application.workbooks.workbook.worksheets.worksheet.Range)">covar</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range1,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range2)</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#critbinom(double, double, double)">critbinom</A></B>(double trials,
double probability_s,
double alpha)</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#cumipmt(double, double, double, double, double, int)">cumipmt</A></B>(double rate,
double nper,
double pv,
double start_period,
double end_period,
int type)</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#cumprinc(double, double, double, double, double, int)">cumprinc</A></B>(double rate,
double nper,
double pv,
double start_period,
double end_period,
int type)</CODE>
<BR>
计算一笔贷款在某一段指定的付款期内从首期到末期所需偿还的累计本金数额。</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#date(int, int, int)">date</A></B>(int year,
int month,
int day)</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#date(long)">date</A></B>(long serial_number)</CODE>
<BR>
返回表示某一特定日期。</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#datedif(java.lang.String, java.lang.String, java.lang.String)">datedif</A></B>(java.lang.String start_date,
java.lang.String end_date,
java.lang.String unit)</CODE>
<BR>
返回两个指定日期间的天数、月数或年数。</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#datevalue(java.lang.String)">datevalue</A></B>(java.lang.String date_text)</CODE>
<BR>
返回代表 date_text 的序列号。</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#daverage(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">daverage</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> database,
double field,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> criteria)</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#daverage(application.workbooks.workbook.worksheets.worksheet.Range, int, application.workbooks.workbook.worksheets.worksheet.Range)">daverage</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> database,
int field,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> criteria)</CODE>
<BR>
返回数据列表或数据库的列中满足指定条件的数值的平均值。</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#day(long)">day</A></B>(long serial_number)</CODE>
<BR>
返回以序列号表示的某日期的天数，用整数 1 到 31 表示。</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#day(java.lang.String)">day</A></B>(java.lang.String serial_number)</CODE>
<BR>
返回以序列号表示的某日期的天数，用整数 1 到 31 表示。</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#days360(java.lang.String, java.lang.String, boolean)">days360</A></B>(java.lang.String start_date,
java.lang.String end_date,
boolean method)</CODE>
<BR>
按照一年 360 天的算法（每个月以 30 天计，一年共计 12 个月）， 返回两日期间相差的天数，这在一些会计计算中将会用到。</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#db(double, double, double, double, double)">db</A></B>(double cost,
double salvage,
double life,
double period,
double month)</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#dcount(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dcount</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> database,
double field,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> criteria)</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#dcounta(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dcounta</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> database,
double field,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> criteria)</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#ddb(double, double, double, double, double)">ddb</A></B>(double cost,
double salvage,
double life,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -