# Excel.Functions class

Extends

## 属性

 context 与该对象关联的请求上下文。The request context associated with the object. 这会将加载项的进程连接到 Office 主机应用程序的进程。This connects the add-in's process to the Office host application's process.

## 方法

 abs(number) 返回一个数的绝对值, 即不带其正负号的数字。Returns the absolute value of a number, a number without its sign. accrInt(issue, firstInterest, settlement, rate, par, frequency, basis, calcMethod) 返回定期付息有价证券的应计利息。Returns the accrued interest for a security that pays periodic interest. accrIntM(issue, settlement, rate, par, basis) 返回到期一次性付息有价证券的应计利息。Returns the accrued interest for a security that pays interest at maturity. acos(number) 返回一个数的反余弦值, 以弧度为单位, 范围为0到 Pi。Returns the arccosine of a number, in radians in the range 0 to Pi. 反余弦值是其余弦值为数字的角度。The arccosine is the angle whose cosine is Number. acosh(number) 返回数字的反双曲余弦值。Returns the inverse hyperbolic cosine of a number. acot(number) 返回一个数字的 arccotangent, 以弧度为单位, 范围为0到 Pi。Returns the arccotangent of a number, in radians in the range 0 to Pi. acoth(number) 返回一个数的反双曲余切。Returns the inverse hyperbolic cotangent of a number. amorDegrc(cost, datePurchased, firstPeriod, salvage, period, rate, basis) 返回每个记帐期的资产的按比例线性折旧。Returns the prorated linear depreciation of an asset for each accounting period. amorLinc(cost, datePurchased, firstPeriod, salvage, period, rate, basis) 返回每个记帐期的资产的按比例线性折旧。Returns the prorated linear depreciation of an asset for each accounting period. and(values) 检查所有参数是否均为 true, 如果所有参数均为 true, 则返回 true。Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. arabic(text) 将罗马数字转换为阿拉伯语。Converts a Roman numeral to Arabic. areas(reference) 返回引用中的区域数。Returns the number of areas in a reference. 区域是连续的单元格区域或单个单元格。An area is a range of contiguous cells or a single cell. asc(text) 将全角 (双字节) 字符更改为半角 (单字节) 字符。Changes full-width (double-byte) characters to half-width (single-byte) characters. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). asin(number) 返回以弧度表示的数字的反正弦值, 其范围为-pi/2 至 Pi/2。Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2. asinh(number) 返回数字的反双曲正弦值。Returns the inverse hyperbolic sine of a number. atan(number) 返回以弧度表示的数字的反正切值, 范围-Pi/2 到 Pi/2。Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2. atan2(xNum, yNum) 返回指定的 x 和 y 坐标的反正切值, 单位为-pi 和 Pi 之间的弧度 (不含-pi)。Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi. atanh(number) 返回数字的反双曲正切值。Returns the inverse hyperbolic tangent of a number. aveDev(values) 返回多个数据点与其平均值的绝对偏差的平均值。Returns the average of the absolute deviations of data points from their mean. 参数可以是数字, 也可以是包含数字的名称、数组或引用。Arguments can be numbers or names, arrays, or references that contain numbers. average(values) 返回其参数的平均值 (算术平均值), 它可以是数字, 也可以是包含数字的名称、数组或引用。Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers. averageA(values) 返回其参数的平均值 (算术平均值), 将参数中的 text 和 FALSE 计算为 0;TRUE 的计算结果为1。Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE evaluates as 1. 参数可以是数字、名称、数组或引用。Arguments can be numbers, names, arrays, or references. averageIf(range, criteria, averageRange) 查找由给定条件或条件指定的单元格的平均值 (算术平均值)。Finds average(arithmetic mean) for the cells specified by a given condition or criteria. averageIfs(averageRange, values) 查找由一组给定条件或条件指定的单元格的平均值 (算术平均值)。Finds average(arithmetic mean) for the cells specified by a given set of conditions or criteria. bahtText(number) 将数字转换为文本 (泰铢)。Converts a number to text (baht). base(number, radix, minLength) 将数字转换为具有给定基数 (base) 的文本表示形式。Converts a number into a text representation with the given radix (base). besselI(x, n) 返回修正的贝赛耳函数 In (x)。Returns the modified Bessel function In(x). besselJ(x, n) 返回贝赛耳函数 Jn (x)。Returns the Bessel function Jn(x). besselK(x, n) 返回已修改的贝赛耳函数 Kn (x)。Returns the modified Bessel function Kn(x). besselY(x, n) 返回贝赛耳函数 Yn (x)。Returns the Bessel function Yn(x). beta_Dist(x, alpha, beta, cumulative, A, B) 返回 beta 概率分布函数。Returns the beta probability distribution function. beta_Inv(probability, alpha, beta, A, B) 返回累积 beta 分布的概率密度函数的反函数 (beta。DIST)。Returns the inverse of the cumulative beta probability density function (BETA.DIST). bin2Dec(number) 将二进制数转换为十进制数。Converts a binary number to decimal. bin2Hex(number, places) 将二进制数转换为十六进制数。Converts a binary number to hexadecimal. bin2Oct(number, places) 将二进制数转换为八进制数。Converts a binary number to octal. binom_Dist_Range(trials, probabilityS, numberS, numberS2) 返回使用二项式分布的试验结果的概率。Returns the probability of a trial result using a binomial distribution. binom_Dist(numberS, trials, probabilityS, cumulative) 返回一元二项式分布的概率。Returns the individual term binomial distribution probability. binom_Inv(trials, probabilityS, alpha) 返回使累积二项式分布大于或等于临界值的最小值。Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. bitand(number1, number2) 返回两个数字的按位 "and"。Returns a bitwise 'And' of two numbers. bitlshift(number, shiftAmount) 返回按移位_量位左移的数字。Returns a number shifted left by shift_amount bits. bitor(number1, number2) 返回两个数字的按位 "or"。Returns a bitwise 'Or' of two numbers. bitrshift(number, shiftAmount) 返回按移位_量位右移的数字。Returns a number shifted right by shift_amount bits. bitxor(number1, number2) 返回两个数字的按位 "异或"。Returns a bitwise 'Exclusive Or' of two numbers. ceiling_Math(number, significance, mode) 将数字向上舍入到最接近的整数或最接近的重要性的倍数。Rounds a number up, to the nearest integer or to the nearest multiple of significance. ceiling_Precise(number, significance) 将数字向上舍入到最接近的整数或最接近的重要性的倍数。Rounds a number up, to the nearest integer or to the nearest multiple of significance. char(number) 返回由您的计算机的字符集中的代码编号指定的字符。Returns the character specified by the code number from the character set for your computer. chiSq_Dist_RT(x, degFreedom) 返回 χ2 分布的右尾概率。Returns the right-tailed probability of the chi-squared distribution. chiSq_Dist(x, degFreedom, cumulative) 返回χ2分布的左尾概率。Returns the left-tailed probability of the chi-squared distribution. chiSq_Inv_RT(probability, degFreedom) 返回 χ2 分布的右尾概率的反函数。Returns the inverse of the right-tailed probability of the chi-squared distribution. chiSq_Inv(probability, degFreedom) 返回 χ2 分布的左尾概率的反函数。Returns the inverse of the left-tailed probability of the chi-squared distribution. choose(indexNum, values) 根据索引号从值列表中选择要执行的值或操作。Chooses a value or action to perform from a list of values, based on an index number. clean(text) 删除文本中的所有非打印字符。Removes all nonprintable characters from text. code(text) 返回文本字符串中的第一个字符在计算机使用的字符集中的数字代码。Returns a numeric code for the first character in a text string, in the character set used by your computer. columns(array) 返回数组或引用中的列数。Returns the number of columns in an array or reference. combin(number, numberChosen) 返回从给定的项目数中提取若干项目的组合数。Returns the number of combinations for a given number of items. combina(number, numberChosen) 返回给定数目的项目的组合次数 (以重复)。Returns the number of combinations with repetitions for a given number of items. complex(realNum, iNum, suffix) 将实系数和虚系数转换为复数。Converts real and imaginary coefficients into a complex number. concatenate(values) 将多个文本字符串联接为一个文本字符串。Joins several text strings into one text string. confidence_Norm(alpha, standardDev, size) 使用正态分布返回总体平均值的置信区间。Returns the confidence interval for a population mean, using a normal distribution. confidence_T(alpha, standardDev, size) 使用学生的 T 分布返回总体平均值的置信区间。Returns the confidence interval for a population mean, using a Student's T distribution. convert(number, fromUnit, toUnit) 将数字从一个度量系统转换为另一个度量系统。Converts a number from one measurement system to another. cos(number) 返回角度的余弦值。Returns the cosine of an angle. cosh(number) 返回数字的双曲余弦值。Returns the hyperbolic cosine of a number. cot(number) 返回一个角度的余切。Returns the cotangent of an angle. coth(number) 返回某一数字的双曲余切。Returns the hyperbolic cotangent of a number. count(values) 计算区域中包含数字的单元格的数目。Counts the number of cells in a range that contain numbers. countA(values) 计算区域中非空的单元格的数目。Counts the number of cells in a range that are not empty. countBlank(range) 计算指定单元格区域中的空单元格的数目。Counts the number of empty cells in a specified range of cells. countIf(range, criteria) 计算区域中满足给定条件的单元格的数量。Counts the number of cells within a range that meet the given condition. countIfs(values) 计算由一组给定条件或条件指定的单元格的数目。Counts the number of cells specified by a given set of conditions or criteria. coupDayBs(settlement, maturity, frequency, basis) 返回从息票期开始到结算日的天数。Returns the number of days from the beginning of the coupon period to the settlement date. coupDays(settlement, maturity, frequency, basis) 返回结算日所在的息票期的天数。Returns the number of days in the coupon period that contains the settlement date. coupDaysNc(settlement, maturity, frequency, basis) 返回从结算日到下一个息票日之间的天数。Returns the number of days from the settlement date to the next coupon date. coupNcd(settlement, maturity, frequency, basis) 返回成交日之后的下一个付息日。Returns the next coupon date after the settlement date. coupNum(settlement, maturity, frequency, basis) 返回成交日和到期日之间的应付款息数。Returns the number of coupons payable between the settlement date and maturity date. coupPcd(settlement, maturity, frequency, basis) 返回成交日之前的上一个付息日。Returns the previous coupon date before the settlement date. csc(number) 返回一个角度的余割。Returns the cosecant of an angle. csch(number) 返回角度的双曲余割。Returns the hyperbolic cosecant of an angle. cumIPmt(rate, nper, pv, startPeriod, endPeriod, type) 返回两个时段之间支付的累积利息。Returns the cumulative interest paid between two periods. cumPrinc(rate, nper, pv, startPeriod, endPeriod, type) 返回两个时段之间贷款累积支付的本金。Returns the cumulative principal paid on a loan between two periods. date(year, month, day) 返回表示 Microsoft Excel 日期时间代码中的日期的数字。Returns the number that represents the date in Microsoft Excel date-time code. datevalue(dateText) 将文本格式的日期转换为表示 Microsoft Excel 日期时间代码中的日期的数字。Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code. daverage(database, field, criteria) 计算满足指定条件的列表或数据库的列中的值的平均值。Averages the values in a column in a list or database that match conditions you specify. day(serialNumber) 返回一个月中的某一天, 为1到31之间的数字。Returns the day of the month, a number from 1 to 31. days(endDate, startDate) 返回两个日期之间的天数。Returns the number of days between the two dates. days360(startDate, endDate, method) 根据360年 (12 30 天) 返回两个日期之间的天数。Returns the number of days between two dates based on a 360-day year (twelve 30-day months). db(cost, salvage, life, period, month) 使用固定余额递减法返回指定周期内某项资产的折旧值。Returns the depreciation of an asset for a specified period using the fixed-declining balance method. dbcs(text) 将字符字符串中的半角 (单字节) 字符更改为全角 (双字节) 字符。Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). dcount(database, field, criteria) 计算数据库中与指定条件匹配的记录的字段 (列) 中包含数字的单元格的个数。Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify. dcountA(database, field, criteria) 计算数据库中与您指定的条件相匹配的记录的字段 (列) 中的非空单元格的个数。Counts nonblank cells in the field (column) of records in the database that match the conditions you specify. ddb(cost, salvage, life, period, factor) 使用双倍余额递减法或其他指定方法返回某项资产在指定周期内的折旧值。Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. dec2Bin(number, places) 将十进制数转换为二进制数。Converts a decimal number to binary. dec2Hex(number, places) 将十进制数转换为十六进制数。Converts a decimal number to hexadecimal. dec2Oct(number, places) 将十进制数转换为八进制数。Converts a decimal number to octal. decimal(number, radix) 将给定基数的数字的文本表示形式转换为十进制数。Converts a text representation of a number in a given base into a decimal number. degrees(angle) 将弧度转换为度。Converts radians to degrees. delta(number1, number2) 测试两个数字是否相等。Tests whether two numbers are equal. devSq(values) 返回数据点与其样本平均值的偏差的平方和。Returns the sum of squares of deviations of data points from their sample mean. dget(database, field, criteria) 从数据库中提取与您指定的条件相匹配的单个记录。Extracts from a database a single record that matches the conditions you specify. disc(settlement, maturity, pr, redemption, basis) 返回债券的贴现率。Returns the discount rate for a security. dmax(database, field, criteria) 返回数据库中与指定条件匹配的记录的字段 (列) 中的最大数字。Returns the largest number in the field (column) of records in the database that match the conditions you specify. dmin(database, field, criteria) 返回数据库中与指定条件匹配的记录的字段 (列) 中的最小数字。Returns the smallest number in the field (column) of records in the database that match the conditions you specify. dollar(number, decimals) 使用货币格式将数字转换为文本。Converts a number to text, using currency format. dollarDe(fractionalDollar, fraction) 将以分数表示的货币转换为以十进制数表示的美元价格。Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. dollarFr(decimalDollar, fraction) 将以小数表示的价格转换为以分数表示的美元价格。Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. dproduct(database, field, criteria) 将数据库中与您指定的条件相匹配的记录的字段 (列) 中的值相乘。Multiplies the values in the field (column) of records in the database that match the conditions you specify. dstDev(database, field, criteria) 根据所选数据库条目中的样本估算标准偏差。Estimates the standard deviation based on a sample from selected database entries. dstDevP(database, field, criteria) 根据选定数据库项的整个总体计算标准偏差。Calculates the standard deviation based on the entire population of selected database entries. dsum(database, field, criteria) 在数据库中与您指定的条件相匹配的记录的字段 (列) 中添加数字。Adds the numbers in the field (column) of records in the database that match the conditions you specify. duration(settlement, maturity, coupon, yld, frequency, basis) 返回定期支付利息的债券的年持续时间。Returns the annual duration of a security with periodic interest payments. dvar(database, field, criteria) 根据所选数据库条目中的样本估算方差。Estimates variance based on a sample from selected database entries. dvarP(database, field, criteria) 根据所选数据库条目的样本总体计算方差。Calculates variance based on the entire population of selected database entries. ecma_Ceiling(number, significance) 将数字向上舍入到最接近的整数或最接近的重要性的倍数。Rounds a number up, to the nearest integer or to the nearest multiple of significance. edate(startDate, months) 返回在开始日期之前或之后指定的月数的日期的序列号。Returns the serial number of the date that is the indicated number of months before or after the start date. effect(nominalRate, npery) 返回年的有效利率。Returns the effective annual interest rate. eoMonth(startDate, months) 返回指定月数之前或之后的一个月的最后一天的序列号。Returns the serial number of the last day of the month before or after a specified number of months. erf_Precise(X) 返回错误函数。Returns the error function. erf(lowerLimit, upperLimit) 返回错误函数。Returns the error function. erfC_Precise(X) 返回互补错误函数。Returns the complementary error function. erfC(x) 返回互补错误函数。Returns the complementary error function. error_Type(errorVal) 返回一个与错误值相匹配的数字。Returns a number matching an error value. even(number) 将正数值向上和负数向下舍入到最接近的偶数整数。Rounds a positive number up and negative number down to the nearest even integer. exact(text1, text2) 检查两个文本字符串是否完全相同, 并返回 TRUE 或 FALSE。Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT 是否区分大小写。EXACT is case-sensitive. exp(number) 返回 e 的加上给定数字的次幂。Returns e raised to the power of a given number. expon_Dist(x, lambda, cumulative) 返回指数分布。Returns the exponential distribution. f_Dist_RT(x, degFreedom1, degFreedom2) 返回两个数据集的 (右尾) F 概率分布 (多元化度)。Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. f_Dist(x, degFreedom1, degFreedom2, cumulative) 返回两个数据集的 (左尾) F 概率分布 (多元化度)。Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets. f_Inv_RT(probability, degFreedom1, degFreedom2) 返回 (右尾) F 概率分布的反函数: 如果 p = f.。RT (x,...), 然后是 "INV"。RT (p,...) = x。Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x. f_Inv(probability, degFreedom1, degFreedom2) 返回 (左尾) F 概率分布的反函数: 如果 p = f. (x,...), 则返回 a-f (p,...) = x。Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x. fact(number) 返回一个数的阶乘, 等于 123 ... 多种.Returns the factorial of a number, equal to 123 ... Number. factDouble(number) 返回数字的双倍阶乘。Returns the double factorial of a number. false() 返回逻辑值 FALSE。Returns the logical value FALSE. find(findText, withinText, startNum) 返回另一个文本字符串中一个文本字符串的起始位置。Returns the starting position of one text string within another text string. 查找区分大小写。FIND is case-sensitive. findB(findText, withinText, startNum) 在另一个文本字符串中查找一个文本字符串的起始位置。Finds the starting position of one text string within another text string. FINDB 区分大小写。FINDB is case-sensitive. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). fisher(x) 返回 Fisher 转换。Returns the Fisher transformation. fisherInv(y) 返回 Fisher 转换的反函数: 如果 y = Fisher (x), 则 FISHERINV (y) = x。Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x. fixed(number, decimals, noCommas) 将数字舍入到指定的小数位数, 并以包含或不带逗号的文本的形式返回结果。Rounds a number to the specified number of decimals and returns the result as text with or without commas. floor_Math(number, significance, mode) 将数字向下舍入到最接近的整数或最接近的重要性的倍数。Rounds a number down, to the nearest integer or to the nearest multiple of significance. floor_Precise(number, significance) 将数字向下舍入到最接近的整数或最接近的重要性的倍数。Rounds a number down, to the nearest integer or to the nearest multiple of significance. fv(rate, nper, pmt, pv, type) 基于固定利率和等额分期付款方式，返回某项投资的未来值。Returns the future value of an investment based on periodic, constant payments and a constant interest rate. fvschedule(principal, schedule) 基于一系列复利返回本金的未来值。Returns the future value of an initial principal after applying a series of compound interest rates. gamma_Dist(x, alpha, beta, cumulative) 返回 γ 分布函数值。Returns the gamma distribution. gamma_Inv(probability, alpha, beta) 返回伽玛累积分布的反函数: 如果 p = 伽玛。DIST (x,...), 然后是伽玛。INV (p,...) = x。Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. gamma(x) 返回伽玛函数值。Returns the Gamma function value. gammaLn_Precise(x) 返回伽玛函数的自然对数。Returns the natural logarithm of the gamma function. gammaLn(x) 返回伽玛函数的自然对数。Returns the natural logarithm of the gamma function. gauss(x) 返回小于标准正态累积分布的0.5。Returns 0.5 less than the standard normal cumulative distribution. gcd(values) 返回最大公因数。Returns the greatest common divisor. geoMean(values) 返回正数值数据的数组或区域的几何平均值。Returns the geometric mean of an array or range of positive numeric data. geStep(number, step) 测试数字是否大于阈值。Tests whether a number is greater than a threshold value. harMean(values) 返回正数的数据集的调和平均值: reciprocals 的算术平均值的倒数平均值。Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals. hex2Bin(number, places) 将十六进制数转换为二进制数。Converts a Hexadecimal number to binary. hex2Dec(number) 将十六进制数转换为十进制数。Converts a hexadecimal number to decimal. hex2Oct(number, places) 将十六进制数转换为八进制数。Converts a hexadecimal number to octal. hlookup(lookupValue, tableArray, rowIndexNum, rangeLookup) 在表或值数组的首行查找值, 并从指定行的同一列中返回值。Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify. hour(serialNumber) 将小时返回为从 0 (12:00 A.M.) 到 23 (11:00 下午5点) 的数字。Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). hyperlink(linkLocation, friendlyName) 创建一个快捷方式或跳转, 用于打开存储在硬盘驱动器、网络服务器或 Internet 上的文档。Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet. hypGeom_Dist(sampleS, numberSample, populationS, numberPop, cumulative) 返回超几何分布。Returns the hypergeometric distribution. if(logicalTest, valueIfTrue, valueIfFalse) 检查是否满足条件, 如果为 TRUE, 则返回一个值; 如果为 FALSE, 则返回另一个值。Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. imAbs(inumber) 返回复数的绝对值 (模数)。Returns the absolute value (modulus) of a complex number. imaginary(inumber) 返回复数的虚系数。Returns the imaginary coefficient of a complex number. imArgument(inumber) 返回参数 q, 以弧度表示的角。Returns the argument q, an angle expressed in radians. imConjugate(inumber) 返回复数的共轭复数。Returns the complex conjugate of a complex number. imCos(inumber) 返回复数的余弦值。Returns the cosine of a complex number. imCosh(inumber) 返回复数的双曲余弦值。Returns the hyperbolic cosine of a complex number. imCot(inumber) 返回复数的余切值。Returns the cotangent of a complex number. imCsc(inumber) 返回复数的余割值。Returns the cosecant of a complex number. imCsch(inumber) 返回复数的双曲余割值。Returns the hyperbolic cosecant of a complex number. imDiv(inumber1, inumber2) 返回两个复数的商。Returns the quotient of two complex numbers. imExp(inumber) 返回复数的指数值。Returns the exponential of a complex number. imLn(inumber) 返回复数的自然对数。Returns the natural logarithm of a complex number. imLog10(inumber) 返回复数的以10为底的对数。Returns the base-10 logarithm of a complex number. imLog2(inumber) 返回复数的以2为底数的对数。Returns the base-2 logarithm of a complex number. imPower(inumber, number) 返回一个复数的整数次幂。Returns a complex number raised to an integer power. imProduct(values) 返回1到255复数的乘积。Returns the product of 1 to 255 complex numbers. imReal(inumber) 返回复数的实系数。Returns the real coefficient of a complex number. imSec(inumber) 返回复数的正割值。Returns the secant of a complex number. imSech(inumber) 返回复数的双曲正割值。Returns the hyperbolic secant of a complex number. imSin(inumber) 返回复数的正弦值。Returns the sine of a complex number. imSinh(inumber) 返回复数的双曲正弦值。Returns the hyperbolic sine of a complex number. imSqrt(inumber) 返回复数的平方根。Returns the square root of a complex number. imSub(inumber1, inumber2) 返回两个复数的差。Returns the difference of two complex numbers. imSum(values) 返回复数的和。Returns the sum of complex numbers. imTan(inumber) 返回复数的正切值。Returns the tangent of a complex number. int(number) 将数字向下舍入到最接近的整数。Rounds a number down to the nearest integer. intRate(settlement, maturity, investment, redemption, basis) 返回完全投资型债券的利率。Returns the interest rate for a fully invested security. ipmt(rate, per, nper, pv, fv, type) 根据固定利率和等额分期付款方式, 返回某项投资在给定期间内的利息支付额。Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate. irr(values, guess) 返回一系列现金流的内部收益率。Returns the internal rate of return for a series of cash flows. isErr(value) 检查值是否#为不包括# # # # # #N/a 的错误 (value!, REF!, DIV/0!, NUM!, NAME?, 或 NULL!), 并返回 TRUE 或 FALSE。Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSE. isError(value) 检查某个值是否为错误 (#N/a、 #value!、 #REF!、 #DIV/0!、 #NUM!、 #NAME? 或#NULL!), 并返回 TRUE 或 FALSE。Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE. isEven(number) 如果数字为偶数, 则返回 TRUE。Returns TRUE if the number is even. isFormula(reference) 检查引用是否指向包含公式的单元格, 并返回 TRUE 或 FALSE。Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE. isLogical(value) 检查值是否为逻辑值 (TRUE 或 false), 并返回 TRUE 或 false。Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE. isNA(value) 检查值是否为#N/a, 并返回 TRUE 或 FALSE。Checks whether a value is #N/A, and returns TRUE or FALSE. isNonText(value) 检查值是否不是文本 (空白单元格不是文本), 并返回 TRUE 或 FALSE。Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE. isNumber(value) 检查某个值是否为数字, 并返回 TRUE 或 FALSE。Checks whether a value is a number, and returns TRUE or FALSE. iso_Ceiling(number, significance) 将数字向上舍入到最接近的整数或最接近的重要性的倍数。Rounds a number up, to the nearest integer or to the nearest multiple of significance. isOdd(number) 如果数字为奇数, 则返回 TRUE。Returns TRUE if the number is odd. isoWeekNum(date) 返回给定日期在一年中的 ISO 周数。Returns the ISO week number in the year for a given date. ispmt(rate, per, nper, pv) 返回特定投资期内支付的利息。Returns the interest paid during a specific period of an investment. isref(value) 检查值是否为引用, 并返回 TRUE 或 FALSE。Checks whether a value is a reference, and returns TRUE or FALSE. isText(value) 检查值是否为文本, 并返回 TRUE 或 FALSE。Checks whether a value is text, and returns TRUE or FALSE. kurt(values) 返回一组数据的峰值。Returns the kurtosis of a data set. large(array, k) 返回数据集中第 k 个最大值。Returns the k-th largest value in a data set. 例如, 第五个最大的数字。For example, the fifth largest number. lcm(values) 返回最小公倍数。Returns the least common multiple. left(text, numChars) 返回文本字符串开头的指定数量的字符。Returns the specified number of characters from the start of a text string. leftb(text, numBytes) 返回文本字符串开头的指定数量的字符。Returns the specified number of characters from the start of a text string. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). len(text) 返回文本字符串中的字符数。Returns the number of characters in a text string. lenb(text) 返回文本字符串中的字符数。Returns the number of characters in a text string. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). ln(number) 返回数字的自然对数。Returns the natural logarithm of a number. log(number, base) 按所指定的底数，返回一个数的对数。Returns the logarithm of a number to the base you specify. log10(number) 返回以 10 为底的对数。Returns the base-10 logarithm of a number. logNorm_Dist(x, mean, standardDev, cumulative) 返回 x 的对数分布, 其中 ln (x) 通常使用参数均值和标准_dev 进行分布。Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. logNorm_Inv(probability, mean, standardDev) 返回 x 的对数累积分布函数的反函数, 其中 ln (x) 通常使用参数均值和标准_dev 进行分布。Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. lookup(lookupValue, lookupVector, resultVector) 从单行或单列区域或从一个数组中查找值。Looks up a value either from a one-row or one-column range or from an array. 提供用于向后兼容性。Provided for backward compatibility. lower(text) 将文本字符串中的所有字母转换为小写形式。Converts all letters in a text string to lowercase. match(lookupValue, lookupArray, matchType) 返回在指定方式下与指定数值匹配的数组中元素的相应位置。Returns the relative position of an item in an array that matches a specified value in a specified order. max(values) 返回一组值中的最大值。Returns the largest value in a set of values. 忽略逻辑值和文本。Ignores logical values and text. maxA(values) 返回一组值中的最大值。Returns the largest value in a set of values. 不忽略逻辑值和文本。Does not ignore logical values and text. mduration(settlement, maturity, coupon, yld, frequency, basis) 返回 Macauley 的已修改持续时间, 其假定值为 \$100 的有价证券。Returns the Macauley modified duration for a security with an assumed par value of \$100. median(values) 返回中值, 或指定的编号集中的数字。Returns the median, or the number in the middle of the set of given numbers. mid(text, startNum, numChars) 在给定起始位置和长度的情况下, 返回文本字符串中间的字符。Returns the characters from the middle of a text string, given a starting position and length. midb(text, startNum, numBytes) 在给定起始位置和长度的情况下, 返回文本字符串中间的字符。Returns characters from the middle of a text string, given a starting position and length. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). min(values) 返回一组值中的最小值。Returns the smallest number in a set of values. 忽略逻辑值和文本。Ignores logical values and text. minA(values) 返回一组值中的最小值。Returns the smallest value in a set of values. 不忽略逻辑值和文本。Does not ignore logical values and text. minute(serialNumber) 返回分钟, 是介于0到59之间的数字。Returns the minute, a number from 0 to 59. mirr(values, financeRate, reinvestRate) 返回一系列定期现金流的内部收益率, 同时考虑投资成本和现金利率利息。Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash. mod(number, divisor) 返回一个数除以一个除数后所得的余数。Returns the remainder after a number is divided by a divisor. month(serialNumber) 返回月, 是 1 (一月) 到 12 (十二月) 之间的一个数字。Returns the month, a number from 1 (January) to 12 (December). mround(number, multiple) 返回参数按指定基数舍入后的数值。Returns a number rounded to the desired multiple. multiNomial(values) 返回一组数字的 multinomial。Returns the multinomial of a set of numbers. n(value) 将非数字值转换为数字, 将日期转换为序列号, 如果为 1, 则为 1, 任何其他值都设置为 0 (零)。Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero). na() 返回错误值#N/A (值不可用)。Returns the error value #N/A (value not available). negBinom_Dist(numberF, numberS, probabilityS, cumulative) 返回负二项式分布的概率, 在第一次成功前__的数字发生次数为 f, 概率为成功的概率_为1。Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_s probability of a success. networkDays_Intl(startDate, endDate, weekend, holidays) 使用自定义周末参数返回两个日期之间的完整工作日数。Returns the number of whole workdays between two dates with custom weekend parameters. networkDays(startDate, endDate, holidays) 返回两个日期之间的完整工作日数。Returns the number of whole workdays between two dates. nominal(effectRate, npery) 返回年的名义利率。Returns the annual nominal interest rate. norm_Dist(x, mean, standardDev, cumulative) 返回指定平均值和标准偏差的正态分布。Returns the normal distribution for the specified mean and standard deviation. norm_Inv(probability, mean, standardDev) 返回指定平均值和标准偏差的正态累积分布函数的反函数。Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. norm_S_Dist(z, cumulative) 返回标准正态分布 (其平均值为零, 标准偏差为 1)。Returns the standard normal distribution (has a mean of zero and a standard deviation of one). norm_S_Inv(probability) 返回标准正态累积分布 (其平均值为零, 标准偏差为 1) 的反函数。Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one). not(logical) 将 FALSE 更改为 true, 或将 true 更改为 FALSE。Changes FALSE to TRUE, or TRUE to FALSE. now() 返回日期和时间格式的当前日期和时间。Returns the current date and time formatted as a date and time. nper(rate, pmt, pv, fv, type) 基于固定利率及等额分期付款方式，返回某项投资的总期数。Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. npv(rate, values) 返回基于贴现率和一系列未来付款 (负值) 和收入 (正值) 的投资净现值。Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values). numberValue(text, decimalSeparator, groupSeparator) 以独立于区域设置的方式将文本转换为数字。Converts text to number in a locale-independent manner. oct2Bin(number, places) 将八进制数转换为二进制数。Converts an octal number to binary. oct2Dec(number) 将八进制数转换为十进制数。Converts an octal number to decimal. oct2Hex(number, places) 将八进制数转换为十六进制数。Converts an octal number to hexadecimal. odd(number) 将正数值向上和负数向下舍入到最接近的奇数整数。Rounds a positive number up and negative number down to the nearest odd integer. oddFPrice(settlement, maturity, issue, firstCoupon, rate, yld, redemption, frequency, basis) 返回第一期为奇数的债券的 \$100 的价格值。Returns the price per \$100 face value of a security with an odd first period. oddFYield(settlement, maturity, issue, firstCoupon, rate, pr, redemption, frequency, basis) 返回第一期为奇数的有价证券的收益率。Returns the yield of a security with an odd first period. oddLPrice(settlement, maturity, lastInterest, rate, yld, redemption, frequency, basis) 返回与前一期为奇数的有价证券的每 \$100 的价格值。Returns the price per \$100 face value of a security with an odd last period. oddLYield(settlement, maturity, lastInterest, rate, pr, redemption, frequency, basis) 返回最后一期为奇数的有价证券的收益率。Returns the yield of a security with an odd last period. or(values) 检查是否有任何参数为 true, 并返回 true 或 FALSE。Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. 仅当所有参数均为 false 时, 才返回 false。Returns FALSE only if all arguments are FALSE. pduration(rate, pv, fv) 返回投资达到指定值所需的周期数。Returns the number of periods required by an investment to reach a specified value. percentile_Exc(array, k) 返回区域中数值的第 k 个百分点的值，其中 k 的范围是从 0 到 1（不包括 0 和 1）。Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. percentile_Inc(array, k) 返回一个区域中第 k 个百分点的值, 其中 k 介于0到1之间 (含0和 1)。Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. percentRank_Exc(array, x, significance) 以数据集的百分比 (0、1、独占) 的形式返回数据集中的值的排名。Returns the rank of a value in a data set as a percentage of the data set as a percentage (0..1, exclusive) of the data set. percentRank_Inc(array, x, significance) 以数据集的百分比 (0 和 1, 含) 为单位返回数据集中的值的排名。Returns the rank of a value in a data set as a percentage of the data set as a percentage (0..1, inclusive) of the data set. permut(number, numberChosen) 返回可从总计对象中选择的给定数量的对象的排列数。Returns the number of permutations for a given number of objects that can be selected from the total objects. permutationa(number, numberChosen) 返回可从总计对象中选择的给定数量的对象 (使用重复) 的排列次数。Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects. phi(x) 返回标准正态分布的密度函数的值。Returns the value of the density function for a standard normal distribution. pi() 返回 Pi 3.14159265358979 的值, 精确到15位。Returns the value of Pi, 3.14159265358979, accurate to 15 digits. pmt(rate, nper, pv, fv, type) 基于固定利率及等额分期付款方式，计算贷款的每期付款额。Calculates the payment for a loan based on constant payments and a constant interest rate. poisson_Dist(x, mean, cumulative) 返回泊松分布。Returns the Poisson distribution. power(number, power) 返回某数的乘幂结果。Returns the result of a number raised to a power. ppmt(rate, per, nper, pv, fv, type) 基于固定利率和等额分期付款方式, 返回针对给定投资的本金的付款。Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate. price(settlement, maturity, rate, yld, redemption, frequency, basis) 返回定期付息的面值 ￥100 的债券价格。Returns the price per \$100 face value of a security that pays periodic interest. priceDisc(settlement, maturity, discount, redemption, basis) 返回折价发行的面值 ￥100 的债券的价格。Returns the price per \$100 face value of a discounted security. priceMat(settlement, maturity, issue, rate, yld, basis) 返回到期付息的面值 ￥100 的债券的价格。Returns the price per \$100 face value of a security that pays interest at maturity. product(values) 将所有以参数形式给出的数字相乘。Multiplies all the numbers given as arguments. proper(text) 将文本字符串转换为正确的大小写。每个单词的第一个字母为大写, 所有其他字母均为小写。Converts a text string to proper case; the first letter in each word to uppercase, and all other letters to lowercase. pv(rate, nper, pmt, fv, type) 返回一个投资的现值: 一系列未来付款现在的总金额。Returns the present value of an investment: the total amount that a series of future payments is worth now. quartile_Exc(array, quart) 根据0和1之间的百分点值返回数据集的四分位。Returns the quartile of a data set, based on percentile values from 0..1, exclusive. quartile_Inc(array, quart) 根据0和1之间的百分点值 (包括0和 1) 返回数据集的四分位。Returns the quartile of a data set, based on percentile values from 0..1, inclusive. quotient(numerator, denominator) 返回除法的整数部分。Returns the integer portion of a division. radians(angle) 将度转换为弧度。Converts degrees to radians. rand() 返回一个大于或等于0且小于 1 (均匀分布的更改) 的随机数字。Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation). randBetween(bottom, top) 返回指定的数字之间的随机数字。Returns a random number between the numbers you specify. rank_Avg(number, ref, order) 返回数字列表中数字的排位: 其相对于列表中的其他值的大小;如果不止一个值具有相同的秩, 则返回平均排名。Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned. rank_Eq(number, ref, order) 返回数字列表中数字的排位: 其相对于列表中的其他值的大小;如果多个值具有相同的秩, 则返回该集合的最高排名。Returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. rate(nper, pmt, pv, fv, type, guess) 返回贷款或投资在每个期间的利率。Returns the interest rate per period of a loan or an investment. 例如, 对每年 6% 的季度付款使用 6%/4。For example, use 6%/4 for quarterly payments at 6% APR. received(settlement, maturity, investment, discount, basis) 返回完全投资型债券到期收回的金额。Returns the amount received at maturity for a fully invested security. replace(oldText, startNum, numChars, newText) 用不同的文本字符串替换文本字符串的一部分。Replaces part of a text string with a different text string. replaceB(oldText, startNum, numBytes, newText) 用不同的文本字符串替换文本字符串的一部分。Replaces part of a text string with a different text string. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). rept(text, numberTimes) 按照给定的次数重复显示文本。Repeats text a given number of times. 可以通过函数 REPT 来不断地重复显示某一文本字符串，对单元格进行填充。Use REPT to fill a cell with a number of instances of a text string. right(text, numChars) 返回文本字符串末尾的指定数量的字符。Returns the specified number of characters from the end of a text string. rightb(text, numBytes) 返回文本字符串末尾的指定数量的字符。Returns the specified number of characters from the end of a text string. 与双字节字符集 (DBCS) 一起使用。Use with double-byte character sets (DBCS). roman(number, form) 将阿拉伯数字转换为文本形式的罗马数字。Converts an Arabic numeral to Roman, as text. round(number, numDigits) 将数字舍入到指定位数。Rounds a number to a specified number of digits. roundDown(number, numDigits) 将数字向零的方向向下舍入。Rounds a number down, toward zero. roundUp(number, numDigits) 远离零的向上舍入数字。Rounds a number up, away from zero. rows(array) 返回引用或数组中的行数。Returns the number of rows in a reference or array. rri(nper, pv, fv) 返回投资增长的等效利率。Returns an equivalent interest rate for the growth of an investment. sec(number) 返回一个角度的正割。Returns the secant of an angle. sech(number) 返回角度的双曲正割。Returns the hyperbolic secant of an angle. second(serialNumber) 返回第二个, 是介于0到59之间的数字。Returns the second, a number from 0 to 59. seriesSum(x, n, m, coefficients) 返回基于公式的幂级数之和。Returns the sum of a power series based on the formula. sheet(value) 返回引用的工作表的工作表编号。Returns the sheet number of the referenced sheet. sheets(reference) 返回引用中的工作表数。Returns the number of sheets in a reference. sign(number) 返回数字的正负号: 1 如果数字为正数, 则为零; 如果数字为零, 则返回 0; 如果数字为负, 则返回-1。Returns the sign of a number: 1 if the number is positive, zero if the number is zero, or -1 if the number is negative. sin(number) 返回角度的正弦值。Returns the sine of an angle. sinh(number) 返回某一数字的双曲正弦值。Returns the hyperbolic sine of a number. skew_p(values) 基于总体, 返回分布的偏斜度: 一种与其平均值有关的分布不对称程度的特性。Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean. skew(values) 返回分布的偏斜度: 根据其平均值的分布不对称程度的特征。Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean. sln(cost, salvage, life) 返回某项资产一个周期的直线折旧值。Returns the straight-line depreciation of an asset for one period. small(array, k) 返回数据集中第 k 个最小值。Returns the k-th smallest value in a data set. 例如, 第五个最小的数字。For example, the fifth smallest number. sqrt(number) 返回数字的平方根。Returns the square root of a number. sqrtPi(number) 返回的平方根 (number * Pi) 的平方根。Returns the square root of (number * Pi). standardize(x, mean, standardDev) 从平均值和标准偏差的分布中返回一个规范化的值。Returns a normalized value from a distribution characterized by a mean and standard deviation. stDev_P(values) 基于作为参数给定的整个样本总体计算标准偏差 (忽略逻辑值和文本)。Calculates standard deviation based on the entire population given as arguments (ignores logical values and text). stDev_S(values) 估计基于样本的标准偏差 (忽略样本中的逻辑值和文本)。Estimates standard deviation based on a sample (ignores logical values and text in the sample). stDevA(values) 根据样本 (包括逻辑值和文本) 估计标准偏差。Estimates standard deviation based on a sample, including logical values and text. 文本和逻辑值 FALSE 的值为 0;逻辑值 TRUE 的值为1。Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1. stDevPA(values) 基于整个样本总体计算标准偏差, 包括逻辑值和文本。Calculates standard deviation based on an entire population, including logical values and text. 文本和逻辑值 FALSE 的值为 0;逻辑值 TRUE 的值为1。Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1. substitute(text, oldText, newText, instanceNum) 将现有文本替换为文本字符串中的新文本。Replaces existing text with new text in a text string. subtotal(functionNum, values) 返回列表或数据库中的分类汇总。Returns a subtotal in a list or database. sum(values) 对某单元格区域中的所有数字求和。Adds all the numbers in a range of cells. sumIf(range, criteria, sumRange) 添加由给定条件或条件指定的单元格。Adds the cells specified by a given condition or criteria. sumIfs(sumRange, values) 添加由一组给定条件或条件指定的单元格。Adds the cells specified by a given set of conditions or criteria. sumSq(values) 返回参数的平方之和。Returns the sum of the squares of the arguments. 参数可以是数字、数组、名称或对包含数字的单元格的引用。The arguments can be numbers, arrays, names, or references to cells that contain numbers. syd(cost, salvage, life, per) 返回某项资产按年限总和折旧法计算的指定期间的折旧值。Returns the sum-of-years' digits depreciation of an asset for a specified period. t_Dist_2T(x, degFreedom) 返回双尾学生 t 分布。Returns the two-tailed Student's t-distribution. t_Dist_RT(x, degFreedom) 返回右尾学生的 t 分布。Returns the right-tailed Student's t-distribution. t_Dist(x, degFreedom, cumulative) 返回左尾学生的 t 分布。Returns the left-tailed Student's t-distribution. t_Inv_2T(probability, degFreedom) 返回学生 t 分布的双尾逆。Returns the two-tailed inverse of the Student's t-distribution. t_Inv(probability, degFreedom) 返回学生 t 分布的左尾倒角。Returns the left-tailed inverse of the Student's t-distribution. t(value) 检查值是否为文本, 如果是文本, 则返回文本; 如果不是, 则返回双引号 (空文本)。Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not. tan(number) 返回一个角度的正切值。Returns the tangent of an angle. tanh(number) 返回某一数字的双曲正切值。Returns the hyperbolic tangent of a number. tbillEq(settlement, maturity, discount) 返回国库券的等价债券收益。Returns the bond-equivalent yield for a treasury bill. tbillPrice(settlement, maturity, discount) 返回国库券的 \$100 每个面孔值的价格。Returns the price per \$100 face value for a treasury bill. tbillYield(settlement, maturity, pr) 返回国库券的收益率。Returns the yield for a treasury bill. text(value, formatText) 将数值转换为按指定数字格式表示的文本。Converts a value to text in a specific number format. time(hour, minute, second) 将以数字形式给定的小时、分钟和秒转换为 Excel 序列号, 并将其格式设置为时间格式。Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format. timevalue(timeText) 将文本时间转换为 Excel 序列号, 一段时间为 0 (12:00:00 AM) 到 0.999988426 (11:59:59 PM) 之间的数字。Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). 在输入公式后将数字设置为时间格式。Format the number with a time format after entering the formula. today() 返回日期格式的当前日期。Returns the current date formatted as a date. toJSON() 重写 JavaScript `toJSON()`方法, 以便在将 API 对象传递到时提供更有用的输出`JSON.stringify()`Overrides the JavaScript `toJSON()` method in order to provide more useful output when an API object is passed to `JSON.stringify()`. (`JSON.stringify`反过来, 也会调用传递`toJSON`给它的对象的方法。尽管原始的 Excel. 函数对象是 API 对象, 但`toJSON`方法返回一个无格式的 JavaScript 对象 (类型为`Excel.Interfaces.FunctionsData`, in turn, calls the `toJSON` method of the object that is passed to it.) Whereas the original Excel.Functions object is an API object, the `toJSON` method returns a plain JavaScript object (typed as `Excel.Interfaces.FunctionsData`), 其中包含原始对象中所有已加载的子属性的浅表副本。) that contains shallow copies of any loaded child properties from the original object. trim(text) 删除文本字符串中除单词之间的单个空格之外的所有空格。Removes all spaces from a text string except for single spaces between words. trimMean(array, percent) 返回一组数据值的内部部分的平均值。Returns the mean of the interior portion of a set of data values. true() 返回逻辑值 TRUE。Returns the logical value TRUE. trunc(number, numDigits) 通过删除数字的小数或小数部分, 将数字截断为整数。Truncates a number to an integer by removing the decimal, or fractional, part of the number. type(value) 返回一个整数, 表示值的数据类型: number = 1;文本 = 2;逻辑值 = 4;错误值 = 16;array = 64。Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64. unichar(number) 返回由给定数值引用的 Unicode 字符。Returns the Unicode character referenced by the given numeric value. unicode(text) 返回与文本的第一个字符相对应的数字 (代码点)。Returns the number (code point) corresponding to the first character of the text. upper(text) 将文本字符串转换为全部大写字母。Converts a text string to all uppercase letters. usdollar(number, decimals) 使用货币格式将数字转换为文本。Converts a number to text, using currency format. value(text) 将代表数字的文本字符串转换为数字。Converts a text string that represents a number to a number. var_P(values) 计算基于整个总体的方差 (忽略样本总体中的逻辑值和文本)。Calculates variance based on the entire population (ignores logical values and text in the population). var_S(values) 估算基于样本的方差 (忽略样本中的逻辑值和文本)。Estimates variance based on a sample (ignores logical values and text in the sample). varA(values) 估算基于样本的方差, 包括逻辑值和文本。Estimates variance based on a sample, including logical values and text. 文本和逻辑值 FALSE 的值为 0;逻辑值 TRUE 的值为1。Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1. varPA(values) 基于整个样本总体计算方差, 包括逻辑值和文本。Calculates variance based on the entire population, including logical values and text. 文本和逻辑值 FALSE 的值为 0;逻辑值 TRUE 的值为1。Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1. vdb(cost, salvage, life, startPeriod, endPeriod, factor, noSwitch) 使用双倍余额递减法或其他指定的方法，返回指定的任何期间内（包括部分期间）的资产折旧值。Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. vlookup(lookupValue, tableArray, colIndexNum, rangeLookup) 在表中最左边的列中查找值, 然后从指定列的同一行中返回一个值。Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. 默认情况下, 必须按升序对表进行排序。By default, the table must be sorted in an ascending order. weekday(serialNumber, returnType) 返回一个介于1到7之间的数字, 用于标识日期的一周中的某一天。Returns a number from 1 to 7 identifying the day of the week of a date. weekNum(serialNumber, returnType) 返回一年中的周数。Returns the week number in the year. weibull_Dist(x, alpha, beta, cumulative) 返回韦伯分布。Returns the Weibull distribution. workDay_Intl(startDate, days, weekend, holidays) 使用自定义周末参数返回指定数量的工作日之前或之后的日期的序列号。Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. workDay(startDate, days, holidays) 返回指定数量的工作日之前或之后的日期的序列号。Returns the serial number of the date before or after a specified number of workdays. xirr(values, dates, guess) 返回现金流计划的内部收益率。Returns the internal rate of return for a schedule of cash flows. xnpv(rate, values, dates) 返回现金流的日程安排的净现值。Returns the net present value for a schedule of cash flows. xor(values) 返回所有参数的逻辑 "异或"。Returns a logical 'Exclusive Or' of all arguments. year(serialNumber) 返回日期的年份, 为 1900-9999 范围内的整数。Returns the year of a date, an integer in the range 1900 - 9999. yearFrac(startDate, endDate, basis) 返回表示开始_日期和结束_日期之间的整天数的年小部分。Returns the year fraction representing the number of whole days between start_date and end_date. yield(settlement, maturity, rate, pr, redemption, frequency, basis) 返回定期支付利息的债券的收益率。Returns the yield on a security that pays periodic interest. yieldDisc(settlement, maturity, pr, redemption, basis) 返回已贴现债券的年收益。Returns the annual yield for a discounted security. 例如, 国库券。For example, a treasury bill. yieldMat(settlement, maturity, issue, rate, pr, basis) 返回到期付息的债券的年收益。Returns the annual yield of a security that pays interest at maturity. z_Test(array, x, sigma) 返回 z 检验的单尾 P 值。Returns the one-tailed P-value of a z-test.

## 属性详细信息

### context

``context: RequestContext;``

RequestContext

## 方法详细信息

### abs(number)

``abs(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### accrInt(issue, firstInterest, settlement, rate, par, frequency, basis, calcMethod)

``accrInt(issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, firstInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, par: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, calcMethod?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

issue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

firstInterest
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

par
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

calcMethod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### accrIntM(issue, settlement, rate, par, basis)

``accrIntM(issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, par: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

issue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

par
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### acos(number)

``acos(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### acosh(number)

``acosh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### acot(number)

``acot(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### acoth(number)

``acoth(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### amorDegrc(cost, datePurchased, firstPeriod, salvage, period, rate, basis)

``amorDegrc(cost: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, datePurchased: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, firstPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, salvage: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, period: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

cost
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

datePurchased
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

firstPeriod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

salvage
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

period
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### amorLinc(cost, datePurchased, firstPeriod, salvage, period, rate, basis)

``amorLinc(cost: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, datePurchased: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, firstPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, salvage: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, period: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

cost
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

datePurchased
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

firstPeriod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

salvage
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

period
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### and(values)

``and(...values: Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<boolean>;``

#### 参数

values
Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<boolean>

### arabic(text)

``arabic(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### areas(reference)

``areas(reference: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

reference
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### asc(text)

``asc(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### asin(number)

``asin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### asinh(number)

``asinh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### atan(number)

``atan(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### atan2(xNum, yNum)

``atan2(xNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, yNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

xNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

yNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### atanh(number)

``atanh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### aveDev(values)

``aveDev(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### average(values)

``average(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### averageA(values)

``averageA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### averageIf(range, criteria, averageRange)

``averageIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, averageRange?: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

range
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

averageRange
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### averageIfs(averageRange, values)

``averageIfs(averageRange: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> | number | string | boolean>): FunctionResult<number>;``

#### 参数

averageRange
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

values
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> | number | string | boolean>

#### 返回

FunctionResult<number>

### bahtText(number)

``bahtText(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

``base(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, radix: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, minLength?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

minLength
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### besselI(x, n)

``besselI(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

n
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### besselJ(x, n)

``besselJ(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

n
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### besselK(x, n)

``besselK(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

n
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### besselY(x, n)

``besselY(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

n
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### beta_Dist(x, alpha, beta, cumulative, A, B)

``beta_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, A?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, B?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

beta
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

A
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

B
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### beta_Inv(probability, alpha, beta, A, B)

``beta_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, A?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, B?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

beta
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

A
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

B
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bin2Dec(number)

``bin2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bin2Hex(number, places)

``bin2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bin2Oct(number, places)

``bin2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### binom_Dist_Range(trials, probabilityS, numberS, numberS2)

``binom_Dist_Range(trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberS2?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

trials
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

probabilityS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberS2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### binom_Dist(numberS, trials, probabilityS, cumulative)

``binom_Dist(numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

numberS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

trials
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

probabilityS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### binom_Inv(trials, probabilityS, alpha)

``binom_Inv(trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

trials
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

probabilityS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bitand(number1, number2)

``bitand(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bitlshift(number, shiftAmount)

``bitlshift(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, shiftAmount: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

shiftAmount
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bitor(number1, number2)

``bitor(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bitrshift(number, shiftAmount)

``bitrshift(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, shiftAmount: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

shiftAmount
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### bitxor(number1, number2)

``bitxor(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ceiling_Math(number, significance, mode)

``ceiling_Math(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, mode?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

significance
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

mode
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ceiling_Precise(number, significance)

``ceiling_Precise(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

significance
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### char(number)

``char(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### chiSq_Dist_RT(x, degFreedom)

``chiSq_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### chiSq_Dist(x, degFreedom, cumulative)

``chiSq_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### chiSq_Inv_RT(probability, degFreedom)

``chiSq_Inv_RT(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### chiSq_Inv(probability, degFreedom)

``chiSq_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### choose(indexNum, values)

``choose(indexNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ...values: Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number | string | boolean>;``

#### 参数

indexNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

values
Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number | string | boolean>

### clean(text)

``clean(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### code(text)

``code(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### columns(array)

``columns(array: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

array
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### combin(number, numberChosen)

``combin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberChosen
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### combina(number, numberChosen)

``combina(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberChosen
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### complex(realNum, iNum, suffix)

``complex(realNum: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, iNum: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, suffix?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

realNum
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

iNum
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

suffix
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### concatenate(values)

``concatenate(...values: Array<string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<string>;``

#### 参数

values
Array<string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<string>

### confidence_Norm(alpha, standardDev, size)

``confidence_Norm(alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, size: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

size
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### confidence_T(alpha, standardDev, size)

``confidence_T(alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, size: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

size
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### convert(number, fromUnit, toUnit)

``convert(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, fromUnit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, toUnit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

fromUnit
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

toUnit
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### cos(number)

``cos(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### cosh(number)

``cosh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### cot(number)

``cot(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### coth(number)

``coth(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### count(values)

``count(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### countA(values)

``countA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### countBlank(range)

``countBlank(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

range
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### countIf(range, criteria)

``countIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

range
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### countIfs(values)

``countIfs(...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> | number | string | boolean>): FunctionResult<number>;``

#### 参数

values
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> | number | string | boolean>

#### 返回

FunctionResult<number>

### coupDayBs(settlement, maturity, frequency, basis)

``coupDayBs(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### coupDays(settlement, maturity, frequency, basis)

``coupDays(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### coupDaysNc(settlement, maturity, frequency, basis)

``coupDaysNc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### coupNcd(settlement, maturity, frequency, basis)

``coupNcd(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### coupNum(settlement, maturity, frequency, basis)

``coupNum(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### coupPcd(settlement, maturity, frequency, basis)

``coupPcd(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### csc(number)

``csc(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### csch(number)

``csch(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### cumIPmt(rate, nper, pv, startPeriod, endPeriod, type)

``cumIPmt(rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, nper: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pv: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

nper
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pv
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startPeriod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

endPeriod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

type
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### cumPrinc(rate, nper, pv, startPeriod, endPeriod, type)

``cumPrinc(rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, nper: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pv: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

nper
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pv
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startPeriod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

endPeriod
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

type
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### date(year, month, day)

``date(year: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, month: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, day: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

year
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

month
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

day
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### datevalue(dateText)

``datevalue(dateText: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

dateText
string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### daverage(database, field, criteria)

``daverage(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### day(serialNumber)

``day(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### days(endDate, startDate)

``days(endDate: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startDate: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

endDate
string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startDate
string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### days360(startDate, endDate, method)

``days360(startDate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endDate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, method?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

startDate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

endDate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

method
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### db(cost, salvage, life, period, month)

``db(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, period: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, month?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

cost
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

salvage
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

life
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

period
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

month
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dbcs(text)

``dbcs(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### dcount(database, field, criteria)

``dcount(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dcountA(database, field, criteria)

``dcountA(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ddb(cost, salvage, life, period, factor)

``ddb(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, period: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, factor?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

cost
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

salvage
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

life
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

period
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

factor
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dec2Bin(number, places)

``dec2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dec2Hex(number, places)

``dec2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dec2Oct(number, places)

``dec2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

``decimal(number: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, radix: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### degrees(angle)

``degrees(angle: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

angle
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### delta(number1, number2)

``delta(number1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, number2?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number1
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number2
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### devSq(values)

``devSq(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### dget(database, field, criteria)

``dget(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number | boolean | string>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number | boolean | string>

### disc(settlement, maturity, pr, redemption, basis)

``disc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pr
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dmax(database, field, criteria)

``dmax(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dmin(database, field, criteria)

``dmin(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dollar(number, decimals)

``dollar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

decimals
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### dollarDe(fractionalDollar, fraction)

``dollarDe(fractionalDollar: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, fraction: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

fractionalDollar
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

fraction
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dollarFr(decimalDollar, fraction)

``dollarFr(decimalDollar: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, fraction: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

decimalDollar
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

fraction
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dproduct(database, field, criteria)

``dproduct(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dstDev(database, field, criteria)

``dstDev(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dstDevP(database, field, criteria)

``dstDevP(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dsum(database, field, criteria)

``dsum(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### duration(settlement, maturity, coupon, yld, frequency, basis)

``duration(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, coupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

coupon
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

yld
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dvar(database, field, criteria)

``dvar(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### dvarP(database, field, criteria)

``dvarP(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

database
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

field
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

criteria
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ecma_Ceiling(number, significance)

``ecma_Ceiling(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

significance
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### edate(startDate, months)

``edate(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, months: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

months
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### effect(nominalRate, npery)

``effect(nominalRate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, npery: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

nominalRate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

npery
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### eoMonth(startDate, months)

``eoMonth(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, months: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

months
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### erf_Precise(X)

``erf_Precise(X: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

X
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### erf(lowerLimit, upperLimit)

``erf(lowerLimit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, upperLimit?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

lowerLimit
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

upperLimit
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### erfC_Precise(X)

``erfC_Precise(X: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

X
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### erfC(x)

``erfC(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### error_Type(errorVal)

``error_Type(errorVal: string | number | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

errorVal
string | number | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### even(number)

``even(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### exact(text1, text2)

``exact(text1: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, text2: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

text1
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

text2
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### exp(number)

``exp(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### expon_Dist(x, lambda, cumulative)

``expon_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, lambda: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

lambda
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### f_Dist_RT(x, degFreedom1, degFreedom2)

``f_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### f_Dist(x, degFreedom1, degFreedom2, cumulative)

``f_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### f_Inv_RT(probability, degFreedom1, degFreedom2)

``f_Inv_RT(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### f_Inv(probability, degFreedom1, degFreedom2)

``f_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom1
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

degFreedom2
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### fact(number)

``fact(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### factDouble(number)

``factDouble(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### false()

``false(): FunctionResult<boolean>;``

#### 返回

FunctionResult<boolean>

### find(findText, withinText, startNum)

``find(findText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, withinText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startNum?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

findText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

withinText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### findB(findText, withinText, startNum)

``findB(findText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, withinText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startNum?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

findText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

withinText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### fisher(x)

``fisher(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### fisherInv(y)

``fisherInv(y: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

y
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### fixed(number, decimals, noCommas)

``fixed(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, noCommas?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

decimals
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

noCommas
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### floor_Math(number, significance, mode)

``floor_Math(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, mode?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

significance
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

mode
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### floor_Precise(number, significance)

``floor_Precise(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

significance
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### fv(rate, nper, pmt, pv, type)

``fv(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

rate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

nper
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pmt
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

type
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### fvschedule(principal, schedule)

``fvschedule(principal: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, schedule: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

principal
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

schedule
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gamma_Dist(x, alpha, beta, cumulative)

``gamma_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

beta
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gamma_Inv(probability, alpha, beta)

``gamma_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

beta
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gamma(x)

``gamma(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gammaLn_Precise(x)

``gammaLn_Precise(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gammaLn(x)

``gammaLn(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gauss(x)

``gauss(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### gcd(values)

``gcd(...values: Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### geoMean(values)

``geoMean(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### geStep(number, step)

``geStep(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, step?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

step
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### harMean(values)

``harMean(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### hex2Bin(number, places)

``hex2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### hex2Dec(number)

``hex2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### hex2Oct(number, places)

``hex2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### hlookup(lookupValue, tableArray, rowIndexNum, rangeLookup)

``hlookup(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, tableArray: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>, rowIndexNum: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>, rangeLookup?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number | string | boolean>;``

#### 参数

lookupValue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

tableArray
Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>

rowIndexNum
Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>

rangeLookup
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number | string | boolean>

### hour(serialNumber)

``hour(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

``hyperlink(linkLocation: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, friendlyName?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number | string | boolean>;``

#### 参数

string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

friendlyName
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number | string | boolean>

### hypGeom_Dist(sampleS, numberSample, populationS, numberPop, cumulative)

``hypGeom_Dist(sampleS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberSample: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, populationS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberPop: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

sampleS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberSample
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

populationS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberPop
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### if(logicalTest, valueIfTrue, valueIfFalse)

``if(logicalTest: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, valueIfTrue?: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>, valueIfFalse?: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number | string | boolean>;``

#### 参数

logicalTest
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

valueIfTrue
Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>

valueIfFalse
Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number | string | boolean>

### imAbs(inumber)

``imAbs(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imaginary(inumber)

``imaginary(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imArgument(inumber)

``imArgument(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imConjugate(inumber)

``imConjugate(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imCos(inumber)

``imCos(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imCosh(inumber)

``imCosh(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imCot(inumber)

``imCot(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imCsc(inumber)

``imCsc(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imCsch(inumber)

``imCsch(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imDiv(inumber1, inumber2)

``imDiv(inumber1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, inumber2: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber1
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

inumber2
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imExp(inumber)

``imExp(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imLn(inumber)

``imLn(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imLog10(inumber)

``imLog10(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imLog2(inumber)

``imLog2(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imPower(inumber, number)

``imPower(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imProduct(values)

``imProduct(...values: Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>>

Inumber1、Inumber2,.。。介于1到255复数之间的乘法。Inumber1, Inumber2,... are from 1 to 255 complex numbers to multiply.

#### 返回

FunctionResult<number>

### imReal(inumber)

``imReal(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSec(inumber)

``imSec(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSech(inumber)

``imSech(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSin(inumber)

``imSin(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSinh(inumber)

``imSinh(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSqrt(inumber)

``imSqrt(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSub(inumber1, inumber2)

``imSub(inumber1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, inumber2: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber1
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

inumber2
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### imSum(values)

``imSum(...values: Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### imTan(inumber)

``imTan(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

inumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### int(number)

``int(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### intRate(settlement, maturity, investment, redemption, basis)

``intRate(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, investment: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

investment
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ipmt(rate, per, nper, pv, fv, type)

``ipmt(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

rate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

per
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

nper
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

fv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

type
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### irr(values, guess)

``irr(values: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, guess?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

values
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

guess
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### isErr(value)

``isErr(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isError(value)

``isError(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isEven(number)

``isEven(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### isFormula(reference)

``isFormula(reference: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

reference
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isLogical(value)

``isLogical(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isNA(value)

``isNA(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isNonText(value)

``isNonText(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isNumber(value)

``isNumber(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### iso_Ceiling(number, significance)

``iso_Ceiling(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

significance
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### isOdd(number)

``isOdd(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### isoWeekNum(date)

``isoWeekNum(date: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

date
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ispmt(rate, per, nper, pv)

``ispmt(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

rate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

per
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

nper
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### isref(value)

``isref(value: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### isText(value)

``isText(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### kurt(values)

``kurt(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### large(array, k)

``large(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

array
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

k
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### lcm(values)

``lcm(...values: Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### left(text, numChars)

``left(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numChars?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numChars
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### leftb(text, numBytes)

``leftb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numBytes?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numBytes
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### len(text)

``len(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### lenb(text)

``lenb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### ln(number)

``ln(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### log(number, base)

``log(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, base?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

base
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### log10(number)

``log10(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### logNorm_Dist(x, mean, standardDev, cumulative)

``logNorm_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

mean
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### logNorm_Inv(probability, mean, standardDev)

``logNorm_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

mean
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### lookup(lookupValue, lookupVector, resultVector)

``lookup(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, lookupVector: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, resultVector?: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number | string | boolean>;``

#### 参数

lookupValue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

lookupVector
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

resultVector
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number | string | boolean>

### lower(text)

``lower(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### match(lookupValue, lookupArray, matchType)

``match(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, lookupArray: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, matchType?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

lookupValue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

lookupArray
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

matchType
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### max(values)

``max(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### maxA(values)

``maxA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### mduration(settlement, maturity, coupon, yld, frequency, basis)

``mduration(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, coupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

coupon
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

yld
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### median(values)

``median(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### mid(text, startNum, numChars)

``mid(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numChars: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numChars
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### midb(text, startNum, numBytes)

``midb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numBytes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

startNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numBytes
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<string>

### min(values)

``min(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### minA(values)

``minA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### minute(serialNumber)

``minute(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### mirr(values, financeRate, reinvestRate)

``mirr(values: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, financeRate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, reinvestRate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

values
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

financeRate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

reinvestRate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### mod(number, divisor)

``mod(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, divisor: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

divisor
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### month(serialNumber)

``month(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### mround(number, multiple)

``mround(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, multiple: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

multiple
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### multiNomial(values)

``multiNomial(...values: Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

values
Array<number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### n(value)

``n(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### na()

``na(): FunctionResult<number | string>;``

#### 返回

FunctionResult<number | string>

### negBinom_Dist(numberF, numberS, probabilityS, cumulative)

``negBinom_Dist(numberF: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

numberF
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

numberS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

probabilityS
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### networkDays_Intl(startDate, endDate, weekend, holidays)

``networkDays_Intl(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, weekend?: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

endDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

weekend
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

holidays
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### networkDays(startDate, endDate, holidays)

``networkDays(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

endDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

holidays
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### nominal(effectRate, npery)

``nominal(effectRate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, npery: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

effectRate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

npery
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### norm_Dist(x, mean, standardDev, cumulative)

``norm_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

mean
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### norm_Inv(probability, mean, standardDev)

``norm_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

mean
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### norm_S_Dist(z, cumulative)

``norm_S_Dist(z: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

z
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### norm_S_Inv(probability)

``norm_S_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### not(logical)

``not(logical: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<boolean>;``

#### 参数

logical
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<boolean>

### now()

``now(): FunctionResult<number>;``

#### 返回

FunctionResult<number>

### nper(rate, pmt, pv, fv, type)

``nper(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

rate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pmt
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

fv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

type
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### npv(rate, values)

``npv(rate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### 参数

rate
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

#### 返回

FunctionResult<number>

### numberValue(text, decimalSeparator, groupSeparator)

``numberValue(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, decimalSeparator?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, groupSeparator?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

decimalSeparator
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

groupSeparator
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### oct2Bin(number, places)

``oct2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### oct2Dec(number)

``oct2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### oct2Hex(number, places)

``oct2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

places
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### odd(number)

``odd(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### oddFPrice(settlement, maturity, issue, firstCoupon, rate, yld, redemption, frequency, basis)

``oddFPrice(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, firstCoupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

issue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

firstCoupon
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

yld
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### oddFYield(settlement, maturity, issue, firstCoupon, rate, pr, redemption, frequency, basis)

``oddFYield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, firstCoupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

issue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

firstCoupon
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

pr
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>

### oddLPrice(settlement, maturity, lastInterest, rate, yld, redemption, frequency, basis)

``oddLPrice(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, lastInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### 参数

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

lastInterest
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

yld
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

#### 返回

FunctionResult<number>