📄 worksheetfunction.html
字号:
double period,
double factor)</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#dec2bin(long, int)">dec2bin</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#dec2hex(long, int)">dec2hex</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#dec2oct(long, int)">dec2oct</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#degrees(double)">degrees</A></B>(double angle)</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#delta(double, double)">delta</A></B>(double number1,
double number2)</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#devsq(application.workbooks.workbook.worksheets.worksheet.Range)">devsq</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 java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#dget(application.workbooks.workbook.worksheets.worksheet.Range, java.lang.String, application.workbooks.workbook.worksheets.worksheet.Range)">dget</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> database,
java.lang.String 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#disc(java.lang.String, java.lang.String, double, double, int)">disc</A></B>(java.lang.String settlement,
java.lang.String maturity,
double pr,
double redemption,
int 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#dmax(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dmax</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#dmin(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dmin</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#dollar(double, double)">dollar</A></B>(double currencyNumber,
double decimalNumber)</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#dollarde(double, int)">dollarde</A></B>(double fractional_dollar,
int fraction)</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#dollarfr(double, int)">dollarfr</A></B>(double decimal_dollar,
int fraction)</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#dproduct(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dproduct</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#dstdev(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dstdev</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#dstdevp(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dstdevp</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#dsum(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dsum</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#duration(java.lang.String, java.lang.String, double, double, double, int)">duration</A></B>(java.lang.String settlement,
java.lang.String maturity,
double coupon,
double yld,
double frequency,
int 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#dvar(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dvar</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#dvarp(application.workbooks.workbook.worksheets.worksheet.Range, double, application.workbooks.workbook.worksheets.worksheet.Range)">dvarp</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 long</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#edate(java.lang.String, int)">edate</A></B>(java.lang.String start_date,
int method)</CODE>
<BR>
返回指定日期 start_date 之前或之后的指定月份数的序列号。</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/wo⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -