# Excel.Functions class

An object for evaluating Excel functions.

Extends

## Properties

 context The request context associated with the object. This connects the add-in's process to the Office host application's process.

## Methods

 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) 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) 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) 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. Use with double-byte character sets (DBCS). asin(number) 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) Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2. atan2(xNum, yNum) 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) 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) Converts a number into a text representation with the given radix (base). besselI(x, n) Returns the modified Bessel function In(x). besselJ(x, n) Returns the Bessel function Jn(x). besselK(x, n) Returns the modified Bessel function Kn(x). besselY(x, n) Returns the Bessel function Yn(x). beta_Dist(x, alpha, beta, cumulative, A, B) Returns the beta probability distribution function. beta_Inv(probability, alpha, beta, A, B) 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) Returns a bitwise 'And' of two numbers. bitlshift(number, shiftAmount) Returns a number shifted left by shift_amount bits. bitor(number1, number2) 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) Returns the right-tailed probability of the chi-squared distribution. chiSq_Dist(x, degFreedom, cumulative) Returns the left-tailed probability of the chi-squared distribution. chiSq_Inv_RT(probability, degFreedom) Returns the inverse of the right-tailed probability of the chi-squared distribution. chiSq_Inv(probability, degFreedom) 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) 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) Returns the number that represents the date in Microsoft Excel date-time code. datevalue(dateText) 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) 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) 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. 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) Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. exp(number) 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) Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. f_Dist(x, degFreedom1, degFreedom2, cumulative) Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets. f_Inv_RT(probability, degFreedom1, degFreedom2) 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) Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x. fact(number) Returns the factorial of a number, equal to 123... Number. factDouble(number) Returns the double factorial of a number. 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 is case-sensitive. Use with double-byte character sets (DBCS). fisher(x) Returns the Fisher transformation. fisherInv(y) 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) 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) 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) 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) Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). hyperlink(linkLocation, friendlyName) 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) 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) 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) Returns the base-10 logarithm of a complex number. imLog2(inumber) Returns the base-2 logarithm of a complex number. imPower(inumber, number) Returns a complex number raised to an integer power. imProduct(values) 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) 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) Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE. isEven(number) Returns TRUE if the number is even. isFormula(reference) Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE. isLogical(value) Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE. isNA(value) Checks whether a value is #N/A, and returns TRUE or FALSE. isNonText(value) Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE. isNumber(value) 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) Returns TRUE if the number is odd. isoWeekNum(date) 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) Checks whether a value is a reference, and returns TRUE or FALSE. isText(value) Checks whether a value is text, and returns TRUE or FALSE. kurt(values) Returns the kurtosis of a data set. large(array, 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. 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. 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) Returns the base-10 logarithm of a number. logNorm_Dist(x, mean, standardDev, cumulative) Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. logNorm_Inv(probability, mean, standardDev) 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) 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. 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) 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) Returns the month, a number from 1 (January) to 12 (December). mround(number, multiple) Returns a number rounded to the desired multiple. multiNomial(values) Returns the multinomial of a set of numbers. n(value) Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero). na() Returns the error value #N/A (value not available). negBinom_Dist(numberF, numberS, probabilityS, cumulative) 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) Returns the standard normal distribution (has a mean of zero and a standard deviation of one). norm_S_Inv(probability) Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one). not(logical) 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) 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) 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) Checks whether any of the arguments are TRUE, and returns TRUE or 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) Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. percentile_Inc(array, k) Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. percentRank_Exc(array, x, significance) 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) 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() 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) Returns the price per \$100 face value of a security that pays periodic interest. priceDisc(settlement, maturity, discount, redemption, basis) Returns the price per \$100 face value of a discounted security. priceMat(settlement, maturity, issue, rate, yld, basis) 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) Returns the quartile of a data set, based on percentile values from 0..1, exclusive. quartile_Inc(array, quart) 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() 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. 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. Use with double-byte character sets (DBCS). rept(text, numberTimes) Repeats text a given number of times. 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. 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) 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) 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) 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) 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. 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. 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) Returns the two-tailed Student's t-distribution. t_Dist_RT(x, degFreedom) Returns the right-tailed Student's t-distribution. t_Dist(x, degFreedom, cumulative) Returns the left-tailed Student's t-distribution. t_Inv_2T(probability, degFreedom) Returns the two-tailed inverse of the Student's t-distribution. t_Inv(probability, degFreedom) 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) 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) Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format. timevalue(timeText) 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() Overrides the JavaScript `toJSON()` method in order to provide more useful output when an API object is passed to `JSON.stringify()`. (`JSON.stringify`, 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() 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) Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64. unichar(number) 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. 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. 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) 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) 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) Returns the one-tailed P-value of a z-test.

## Property Details

### context

The request context associated with the object. This connects the add-in's process to the Office host application's process.

``context: RequestContext;``

RequestContext

## Method Details

### abs(number)

Returns the absolute value of a number, a number without its sign.

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

#### Parameters

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

Is the real number for which you want the absolute value.

#### Returns

FunctionResult<number>

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

Returns the accrued interest for a security that pays periodic interest.

``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>;``

#### Parameters

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

Is the security's issue date, expressed as a serial date number.

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

Is the security's first interest date, expressed as a serial date number.

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's annual coupon rate.

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

Is the security's par value.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

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

Is a logical value: to accrued interest from issue date = TRUE or omitted; to calculate from last coupon payment date = FALSE.

#### Returns

FunctionResult<number>

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

Returns the accrued interest for a security that pays interest at maturity.

``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>;``

#### Parameters

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

Is the security's issue date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's annual coupon rate.

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

Is the security's par value.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### acos(number)

Returns the arccosine of a number, in radians in the range 0 to Pi. The arccosine is the angle whose cosine is Number.

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

#### Parameters

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

Is the cosine of the angle you want and must be from -1 to 1.

#### Returns

FunctionResult<number>

### acosh(number)

Returns the inverse hyperbolic cosine of a number.

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

#### Parameters

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

Is any real number equal to or greater than 1.

#### Returns

FunctionResult<number>

### acot(number)

Returns the arccotangent of a number, in radians in the range 0 to Pi.

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

#### Parameters

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

Is the cotangent of the angle you want.

#### Returns

FunctionResult<number>

### acoth(number)

Returns the inverse hyperbolic cotangent of a number.

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

#### Parameters

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

Is the hyperbolic cotangent of the angle that you want.

#### Returns

FunctionResult<number>

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

Returns the prorated linear depreciation of an asset for each accounting period.

``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>;``

#### Parameters

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

Is the cost of the asset.

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

Is the date the asset is purchased.

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

Is the date of the end of the first period.

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

Is the salvage value at the end of life of the asset.

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

Is the period.

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

Is the rate of depreciation.

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

Year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days.

#### Returns

FunctionResult<number>

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

Returns the prorated linear depreciation of an asset for each accounting period.

``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>;``

#### Parameters

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

Is the cost of the asset.

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

Is the date the asset is purchased.

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

Is the date of the end of the first period.

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

Is the salvage value at the end of life of the asset.

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

Is the period.

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

Is the rate of depreciation.

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

Year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days.

#### Returns

FunctionResult<number>

### and(values)

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

#### Returns

FunctionResult<boolean>

### arabic(text)

Converts a Roman numeral to Arabic.

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

#### Parameters

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

Is the Roman numeral you want to convert.

#### Returns

FunctionResult<number>

### areas(reference)

Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.

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

#### Parameters

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

Is a reference to a cell or range of cells and can refer to multiple areas.

#### Returns

FunctionResult<number>

### asc(text)

Changes full-width (double-byte) characters to half-width (single-byte) characters. Use with double-byte character sets (DBCS).

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

#### Parameters

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

Is a text, or a reference to a cell containing a text.

#### Returns

FunctionResult<string>

### asin(number)

Returns the arcsine of a number in radians, in the range -Pi/2 to Pi/2.

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

#### Parameters

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

Is the sine of the angle you want and must be from -1 to 1.

#### Returns

FunctionResult<number>

### asinh(number)

Returns the inverse hyperbolic sine of a number.

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

#### Parameters

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

Is any real number equal to or greater than 1.

#### Returns

FunctionResult<number>

### atan(number)

Returns the arctangent of a number in radians, in the range -Pi/2 to Pi/2.

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

#### Parameters

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

Is the tangent of the angle you want.

#### Returns

FunctionResult<number>

### atan2(xNum, yNum)

Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi.

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

#### Parameters

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

Is the x-coordinate of the point.

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

Is the y-coordinate of the point.

#### Returns

FunctionResult<number>

### atanh(number)

Returns the inverse hyperbolic tangent of a number.

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

#### Parameters

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

Is any real number between -1 and 1 excluding -1 and 1.

#### Returns

FunctionResult<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.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 arguments for which you want the average of the absolute deviations.

#### Returns

FunctionResult<number>

### average(values)

Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numeric arguments for which you want the average.

#### Returns

FunctionResult<number>

### averageA(values)

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.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 arguments for which you want the average.

#### Returns

FunctionResult<number>

### averageIf(range, criteria, averageRange)

Finds average(arithmetic mean) for the cells specified by a given condition or criteria.

``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>;``

#### Parameters

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

Is the range of cells you want evaluated.

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

Is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average.

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

Are the actual cells to be used to find the average. If omitted, the cells in range are used.

#### Returns

FunctionResult<number>

### averageIfs(averageRange, values)

Finds average(arithmetic mean) for the cells specified by a given set of conditions or criteria.

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

#### Parameters

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

Are the actual cells to be used to find the average.

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

List of parameters, where the first element of each pair is the Is the range of cells you want evaluated for the particular condition , and the second element is is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average.

#### Returns

FunctionResult<number>

### bahtText(number)

Converts a number to text (baht).

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

#### Parameters

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

Is a number that you want to convert.

#### Returns

FunctionResult<string>

Converts a number into a text representation with the given radix (base).

``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>;``

#### Parameters

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

Is the number that you want to convert.

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

Is the base Radix that you want to convert the number into.

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

Is the minimum length of the returned string. If omitted leading zeros are not added.

#### Returns

FunctionResult<string>

### besselI(x, n)

Returns the modified Bessel function In(x).

``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>;``

#### Parameters

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

Is the value at which to evaluate the function.

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

Is the order of the Bessel function.

#### Returns

FunctionResult<number>

### besselJ(x, n)

Returns the Bessel function Jn(x).

``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>;``

#### Parameters

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

Is the value at which to evaluate the function.

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

Is the order of the Bessel function.

#### Returns

FunctionResult<number>

### besselK(x, n)

Returns the modified Bessel function Kn(x).

``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>;``

#### Parameters

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

Is the value at which to evaluate the function.

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

Is the order of the function.

#### Returns

FunctionResult<number>

### besselY(x, n)

Returns the Bessel function Yn(x).

``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>;``

#### Parameters

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

Is the value at which to evaluate the function.

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

Is the order of the function.

#### Returns

FunctionResult<number>

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

Returns the beta probability distribution function.

``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>;``

#### Parameters

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

Is the value between A and B at which to evaluate the function.

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

Is a parameter to the distribution and must be greater than 0.

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

Is a parameter to the distribution and must be greater than 0.

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

Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.

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

Is an optional lower bound to the interval of x. If omitted, A = 0.

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

Is an optional upper bound to the interval of x. If omitted, B = 1.

#### Returns

FunctionResult<number>

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

Returns the inverse of the cumulative beta probability density function (BETA.DIST).

``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>;``

#### Parameters

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

Is a probability associated with the beta distribution.

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

Is a parameter to the distribution and must be greater than 0.

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

Is a parameter to the distribution and must be greater than 0.

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

Is an optional lower bound to the interval of x. If omitted, A = 0.

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

Is an optional upper bound to the interval of x. If omitted, B = 1.

#### Returns

FunctionResult<number>

### bin2Dec(number)

Converts a binary number to decimal.

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

#### Parameters

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

Is the binary number you want to convert.

#### Returns

FunctionResult<number>

### bin2Hex(number, places)

Converts a binary number to hexadecimal.

``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>;``

#### Parameters

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

Is the binary number you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### bin2Oct(number, places)

Converts a binary number to octal.

``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>;``

#### Parameters

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

Is the binary number you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

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

Returns the probability of a trial result using a binomial distribution.

``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>;``

#### Parameters

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

Is the number of independent trials.

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

Is the probability of success on each trial.

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

Is the number of successes in trials.

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

If provided this function returns the probability that the number of successful trials shall lie between numberS and numberS2.

#### Returns

FunctionResult<number>

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

Returns the individual term binomial distribution probability.

``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>;``

#### Parameters

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

Is the number of successes in trials.

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

Is the number of independent trials.

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

Is the probability of success on each trial.

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

Is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.

#### Returns

FunctionResult<number>

### binom_Inv(trials, probabilityS, alpha)

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

``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>;``

#### Parameters

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

Is the number of Bernoulli trials.

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

Is the probability of success on each trial, a number between 0 and 1 inclusive.

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

Is the criterion value, a number between 0 and 1 inclusive.

#### Returns

FunctionResult<number>

### bitand(number1, number2)

Returns a bitwise 'And' of two numbers.

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

#### Parameters

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

Is the decimal representation of the binary number you want to evaluate.

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

Is the decimal representation of the binary number you want to evaluate.

#### Returns

FunctionResult<number>

### bitlshift(number, shiftAmount)

Returns a number shifted left by shift_amount bits.

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

#### Parameters

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

Is the decimal representation of the binary number you want to evaluate.

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

Is the number of bits that you want to shift Number left by.

#### Returns

FunctionResult<number>

### bitor(number1, number2)

Returns a bitwise 'Or' of two numbers.

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

#### Parameters

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

Is the decimal representation of the binary number you want to evaluate.

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

Is the decimal representation of the binary number you want to evaluate.

#### Returns

FunctionResult<number>

### bitrshift(number, shiftAmount)

Returns a number shifted right by shift_amount bits.

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

#### Parameters

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

Is the decimal representation of the binary number you want to evaluate.

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

Is the number of bits that you want to shift Number right by.

#### Returns

FunctionResult<number>

### bitxor(number1, number2)

Returns a bitwise 'Exclusive Or' of two numbers.

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

#### Parameters

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

Is the decimal representation of the binary number you want to evaluate.

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

Is the decimal representation of the binary number you want to evaluate.

#### Returns

FunctionResult<number>

### ceiling_Math(number, significance, mode)

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

``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>;``

#### Parameters

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

Is the value you want to round.

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

Is the multiple to which you want to round.

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

When given and nonzero this function will round away from zero.

#### Returns

FunctionResult<number>

### ceiling_Precise(number, significance)

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

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

#### Parameters

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

Is the value you want to round.

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

Is the multiple to which you want to round.

#### Returns

FunctionResult<number>

### char(number)

Returns the character specified by the code number from the character set for your computer.

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

#### Parameters

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

Is a number between 1 and 255 specifying which character you want.

#### Returns

FunctionResult<string>

### chiSq_Dist_RT(x, degFreedom)

Returns the right-tailed probability of the chi-squared distribution.

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

#### Parameters

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

Is the value at which you want to evaluate the distribution, a nonnegative number.

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

Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.

#### Returns

FunctionResult<number>

### chiSq_Dist(x, degFreedom, cumulative)

Returns the left-tailed probability of the chi-squared distribution.

``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>;``

#### Parameters

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

Is the value at which you want to evaluate the distribution, a nonnegative number.

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

Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.

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

Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.

#### Returns

FunctionResult<number>

### chiSq_Inv_RT(probability, degFreedom)

Returns the inverse of the right-tailed probability of the chi-squared distribution.

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

#### Parameters

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

Is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive.

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

Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.

#### Returns

FunctionResult<number>

### chiSq_Inv(probability, degFreedom)

Returns the inverse of the left-tailed probability of the chi-squared distribution.

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

#### Parameters

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

Is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive.

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

Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.

#### Returns

FunctionResult<number>

### choose(indexNum, values)

Chooses a value or action to perform from a list of values, based on an index number.

``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>;``

#### Parameters

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

Specifies which value argument is selected. indexNum must be between 1 and 254, or a formula or a reference to a number between 1 and 254.

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

List of parameters, whose elements are 1 to 254 numbers, cell references, defined names, formulas, functions, or text arguments from which CHOOSE selects.

#### Returns

FunctionResult<number | string | boolean>

### clean(text)

Removes all nonprintable characters from text.

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

#### Parameters

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

Is any worksheet information from which you want to remove nonprintable characters.

#### Returns

FunctionResult<string>

### code(text)

Returns a numeric code for the first character in a text string, in the character set used by your computer.

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

#### Parameters

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

Is the text for which you want the code of the first character.

#### Returns

FunctionResult<number>

### columns(array)

Returns the number of columns in an array or reference.

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

#### Parameters

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

Is an array or array formula, or a reference to a range of cells for which you want the number of columns.

#### Returns

FunctionResult<number>

### combin(number, numberChosen)

Returns the number of combinations for a given number of items.

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

#### Parameters

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

Is the total number of items.

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

Is the number of items in each combination.

#### Returns

FunctionResult<number>

### combina(number, numberChosen)

Returns the number of combinations with repetitions for a given number of items.

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

#### Parameters

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

Is the total number of items.

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

Is the number of items in each combination.

#### Returns

FunctionResult<number>

### complex(realNum, iNum, suffix)

Converts real and imaginary coefficients into a complex number.

``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>;``

#### Parameters

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

Is the real coefficient of the complex number.

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

Is the imaginary coefficient of the complex number.

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

Is the suffix for the imaginary component of the complex number.

#### Returns

FunctionResult<number>

### concatenate(values)

Joins several text strings into one text string.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 text strings to be joined into a single text string and can be text strings, numbers, or single-cell references.

#### Returns

FunctionResult<string>

### confidence_Norm(alpha, standardDev, size)

Returns the confidence interval for a population mean, using a normal distribution.

``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>;``

#### Parameters

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

Is the significance level used to compute the confidence level, a number greater than 0 and less than 1.

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

Is the population standard deviation for the data range and is assumed to be known. standardDev must be greater than 0.

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

Is the sample size.

#### Returns

FunctionResult<number>

### confidence_T(alpha, standardDev, size)

Returns the confidence interval for a population mean, using a Student's T distribution.

``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>;``

#### Parameters

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

Is the significance level used to compute the confidence level, a number greater than 0 and less than 1.

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

Is the population standard deviation for the data range and is assumed to be known. standardDev must be greater than 0.

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

Is the sample size.

#### Returns

FunctionResult<number>

### convert(number, fromUnit, toUnit)

Converts a number from one measurement system to another.

``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>;``

#### Parameters

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

Is the value in from_units to convert.

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

Is the units for number.

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

Is the units for the result.

#### Returns

FunctionResult<number>

### cos(number)

Returns the cosine of an angle.

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

#### Parameters

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

Is the angle in radians for which you want the cosine.

#### Returns

FunctionResult<number>

### cosh(number)

Returns the hyperbolic cosine of a number.

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

#### Parameters

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

Is any real number.

#### Returns

FunctionResult<number>

### cot(number)

Returns the cotangent of an angle.

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

#### Parameters

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

Is the angle in radians for which you want the cotangent.

#### Returns

FunctionResult<number>

### coth(number)

Returns the hyperbolic cotangent of a number.

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

#### Parameters

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

Is the angle in radians for which you want the hyperbolic cotangent.

#### Returns

FunctionResult<number>

### count(values)

Counts the number of cells in a range that contain numbers.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 arguments that can contain or refer to a variety of different types of data, but only numbers are counted.

#### Returns

FunctionResult<number>

### countA(values)

Counts the number of cells in a range that are not empty.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 arguments representing the values and cells you want to count. Values can be any type of information.

#### Returns

FunctionResult<number>

### countBlank(range)

Counts the number of empty cells in a specified range of cells.

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

#### Parameters

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

Is the range from which you want to count the empty cells.

#### Returns

FunctionResult<number>

### countIf(range, criteria)

Counts the number of cells within a range that meet the given condition.

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

#### Parameters

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

Is the range of cells from which you want to count nonblank cells.

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

Is the condition in the form of a number, expression, or text that defines which cells will be counted.

#### Returns

FunctionResult<number>

### countIfs(values)

Counts the number of cells specified by a given set of conditions or criteria.

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

#### Parameters

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

List of parameters, where the first element of each pair is the Is the range of cells you want evaluated for the particular condition , and the second element is is the condition in the form of a number, expression, or text that defines which cells will be counted.

#### Returns

FunctionResult<number>

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

Returns the number of days from the beginning of the coupon period to the settlement date.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

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

Returns the number of days in the coupon period that contains the settlement date.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

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

Returns the number of days from the settlement date to the next coupon date.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

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

Returns the next coupon date after the settlement date.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

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

Returns the number of coupons payable between the settlement date and maturity date.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

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

Returns the previous coupon date before the settlement date.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### csc(number)

Returns the cosecant of an angle.

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

#### Parameters

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

Is the angle in radians for which you want the cosecant.

#### Returns

FunctionResult<number>

### csch(number)

Returns the hyperbolic cosecant of an angle.

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

#### Parameters

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

Is the angle in radians for which you want the hyperbolic cosecant.

#### Returns

FunctionResult<number>

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

Returns the cumulative interest paid between two periods.

``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>;``

#### Parameters

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

Is the interest rate.

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

Is the total number of payment periods.

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

Is the present value.

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

Is the first period in the calculation.

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

Is the last period in the calculation.

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

Is the timing of the payment.

#### Returns

FunctionResult<number>

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

Returns the cumulative principal paid on a loan between two periods.

``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>;``

#### Parameters

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

Is the interest rate.

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

Is the total number of payment periods.

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

Is the present value.

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

Is the first period in the calculation.

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

Is the last period in the calculation.

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

Is the timing of the payment.

#### Returns

FunctionResult<number>

### date(year, month, day)

Returns the number that represents the date in Microsoft Excel date-time code.

``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>;``

#### Parameters

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

Is a number from 1900 or 1904 (depending on the workbook's date system) to 9999.

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

Is a number from 1 to 12 representing the month of the year.

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

Is a number from 1 to 31 representing the day of the month.

#### Returns

FunctionResult<number>

### datevalue(dateText)

Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code.

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

#### Parameters

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

Is text that represents a date in a Microsoft Excel date format, between 1/1/1900 or 1/1/1904 (depending on the workbook's date system) and 12/31/9999.

#### Returns

FunctionResult<number>

### daverage(database, field, criteria)

Averages the values in a column in a list or database that match conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### day(serialNumber)

Returns the day of the month, a number from 1 to 31.

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

#### Parameters

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

Is a number in the date-time code used by Microsoft Excel.

#### Returns

FunctionResult<number>

### days(endDate, startDate)

Returns the number of days between the two dates.

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

#### Parameters

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

startDate and endDate are the two dates between which you want to know the number of days.

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

startDate and endDate are the two dates between which you want to know the number of days.

#### Returns

FunctionResult<number>

### days360(startDate, endDate, method)

Returns the number of days between two dates based on a 360-day year (twelve 30-day months).

``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>;``

#### Parameters

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

startDate and endDate are the two dates between which you want to know the number of days.

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

startDate and endDate are the two dates between which you want to know the number of days.

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

Is a logical value specifying the calculation method: U.S. (NASD) = FALSE or omitted; European = TRUE.

#### Returns

FunctionResult<number>

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

Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

``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>;``

#### Parameters

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

Is the initial cost of the asset.

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

Is the salvage value at the end of the life of the asset.

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

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

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

Is the period for which you want to calculate the depreciation. Period must use the same units as Life.

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

Is the number of months in the first year. If month is omitted, it is assumed to be 12.

#### Returns

FunctionResult<number>

### dbcs(text)

Changes half-width (single-byte) characters within a character string to full-width (double-byte) characters. Use with double-byte character sets (DBCS).

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

#### Parameters

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

Is a text, or a reference to a cell containing a text.

#### Returns

FunctionResult<string>

### dcount(database, field, criteria)

Counts the cells containing numbers in the field (column) of records in the database that match the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dcountA(database, field, criteria)

Counts nonblank cells in the field (column) of records in the database that match the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### 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.

``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>;``

#### Parameters

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

Is the initial cost of the asset.

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

Is the salvage value at the end of the life of the asset.

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

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

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

Is the period for which you want to calculate the depreciation. Period must use the same units as Life.

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

Is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method).

#### Returns

FunctionResult<number>

### dec2Bin(number, places)

Converts a decimal number to binary.

``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>;``

#### Parameters

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

Is the decimal integer you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### dec2Hex(number, places)

Converts a decimal number to hexadecimal.

``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>;``

#### Parameters

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

Is the decimal integer you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### dec2Oct(number, places)

Converts a decimal number to octal.

``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>;``

#### Parameters

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

Is the decimal integer you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

Converts a text representation of a number in a given base into a decimal number.

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

#### Parameters

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

Is the number that you want to convert.

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

Is the base Radix of the number you are converting.

#### Returns

FunctionResult<number>

### degrees(angle)

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

#### Parameters

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

Is the angle in radians that you want to convert.

#### Returns

FunctionResult<number>

### delta(number1, number2)

Tests whether two numbers are equal.

``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>;``

#### Parameters

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

Is the first number.

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

Is the second number.

#### Returns

FunctionResult<number>

### devSq(values)

Returns the sum of squares of deviations of data points from their sample mean.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 arguments, or an array or array reference, on which you want DEVSQ to calculate.

#### Returns

FunctionResult<number>

### dget(database, field, criteria)

Extracts from a database a single record that matches the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number | boolean | string>

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

Returns the discount rate for a security.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's price per \$100 face value.

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

Is the security's redemption value per \$100 face value.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### dmax(database, field, criteria)

Returns the largest number in the field (column) of records in the database that match the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dmin(database, field, criteria)

Returns the smallest number in the field (column) of records in the database that match the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dollar(number, decimals)

Converts a number to text, using currency format.

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

#### Parameters

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

Is a number, a reference to a cell containing a number, or a formula that evaluates to a number.

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

Is the number of digits to the right of the decimal point. The number is rounded as necessary; if omitted, Decimals = 2.

#### Returns

FunctionResult<string>

### dollarDe(fractionalDollar, fraction)

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

``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>;``

#### Parameters

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

Is a number expressed as a fraction.

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

Is the integer to use in the denominator of the fraction.

#### Returns

FunctionResult<number>

### dollarFr(decimalDollar, fraction)

Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a 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>;``

#### Parameters

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

Is a decimal number.

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

Is the integer to use in the denominator of a fraction.

#### Returns

FunctionResult<number>

### dproduct(database, field, criteria)

Multiplies the values in the field (column) of records in the database that match the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dstDev(database, field, criteria)

Estimates the standard deviation based on a sample from selected database entries.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dstDevP(database, field, criteria)

Calculates the standard deviation based on the entire population of selected database entries.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dsum(database, field, criteria)

Adds the numbers in the field (column) of records in the database that match the conditions you specify.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

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

Returns the annual duration of a security with periodic interest payments.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's annual coupon rate.

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

Is the security's annual yield.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### dvar(database, field, criteria)

Estimates variance based on a sample from selected database entries.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### dvarP(database, field, criteria)

Calculates variance based on the entire population of selected database entries.

``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>;``

#### Parameters

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

Is the range of cells that makes up the list or database. A database is a list of related data.

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

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

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

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.

#### Returns

FunctionResult<number>

### ecma_Ceiling(number, significance)

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

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

#### Parameters

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

Is the value you want to round.

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

Is the multiple to which you want to round.

#### Returns

FunctionResult<number>

### edate(startDate, months)

Returns the serial number of the date that is the indicated number of months before or after the start date.

``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>;``

#### Parameters

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

Is a serial date number that represents the start date.

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

Is the number of months before or after startDate.

#### Returns

FunctionResult<number>

### effect(nominalRate, npery)

Returns the effective annual interest rate.

``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>;``

#### Parameters

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

Is the nominal interest rate.

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

Is the number of compounding periods per year.

#### Returns

FunctionResult<number>

### eoMonth(startDate, months)

Returns the serial number of the last day of the month before or after a specified number of 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>;``

#### Parameters

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

Is a serial date number that represents the start date.

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

Is the number of months before or after the startDate.

#### Returns

FunctionResult<number>

### erf_Precise(X)

Returns the error function.

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

#### Parameters

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

Is the lower bound for integrating ERF.PRECISE.

#### Returns

FunctionResult<number>

### erf(lowerLimit, upperLimit)

Returns the error function.

``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>;``

#### Parameters

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

Is the lower bound for integrating ERF.

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

Is the upper bound for integrating ERF.

#### Returns

FunctionResult<number>

### erfC_Precise(X)

Returns the complementary error function.

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

#### Parameters

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

Is the lower bound for integrating ERFC.PRECISE.

#### Returns

FunctionResult<number>

### erfC(x)

Returns the complementary error function.

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

#### Parameters

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

Is the lower bound for integrating ERF.

#### Returns

FunctionResult<number>

### error_Type(errorVal)

Returns a number matching an error value.

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

#### Parameters

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

Is the error value for which you want the identifying number, and can be an actual error value or a reference to a cell containing an error value.

#### Returns

FunctionResult<number>

### even(number)

Rounds a positive number up and negative number down to the nearest even integer.

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

#### Parameters

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

Is the value to round.

#### Returns

FunctionResult<number>

### exact(text1, text2)

Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.

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

#### Parameters

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

Is the first text string.

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

Is the second text string.

#### Returns

FunctionResult<boolean>

### exp(number)

Returns e raised to the power of a given number.

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

#### Parameters

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

Is the exponent applied to the base e. The constant e equals 2.71828182845904, the base of the natural logarithm.

#### Returns

FunctionResult<number>

### expon_Dist(x, lambda, cumulative)

Returns the exponential distribution.

``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>;``

#### Parameters

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

Is the value of the function, a nonnegative number.

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

Is the parameter value, a positive number.

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

Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.

#### Returns

FunctionResult<number>

### f_Dist_RT(x, degFreedom1, degFreedom2)

Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.

``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>;``

#### Parameters

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

Is the value at which to evaluate the function, a nonnegative number.

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

Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

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

Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

#### Returns

FunctionResult<number>

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

Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets.

``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>;``

#### Parameters

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

Is the value at which to evaluate the function, a nonnegative number.

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

Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

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

Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

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

Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.

#### Returns

FunctionResult<number>

### f_Inv_RT(probability, degFreedom1, degFreedom2)

Returns the inverse of the (right-tailed) F probability distribution: if p = F.DIST.RT(x,...), then F.INV.RT(p,...) = x.

``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>;``

#### Parameters

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

Is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive.

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

Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

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

Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

#### Returns

FunctionResult<number>

### f_Inv(probability, degFreedom1, degFreedom2)

Returns the inverse of the (left-tailed) F probability distribution: if p = F.DIST(x,...), then F.INV(p,...) = x.

``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>;``

#### Parameters

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

Is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive.

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

Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

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

Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.

#### Returns

FunctionResult<number>

### fact(number)

Returns the factorial of a number, equal to 123... Number.

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

#### Parameters

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

Is the nonnegative number you want the factorial of.

#### Returns

FunctionResult<number>

### factDouble(number)

Returns the double factorial of a number.

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

#### Parameters

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

Is the value for which to return the double factorial.

#### Returns

FunctionResult<number>

### false()

Returns the logical value FALSE.

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

#### Returns

FunctionResult<boolean>

### find(findText, withinText, startNum)

Returns the starting position of one text string within another text string. FIND is case-sensitive.

``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>;``

#### Parameters

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

Is the text you want to find. Use double quotes (empty text) to match the first character in withinText; wildcard characters not allowed.

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

Is the text containing the text you want to find.

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

Specifies the character at which to start the search. The first character in withinText is character number 1. If omitted, startNum = 1.

#### Returns

FunctionResult<number>

### findB(findText, withinText, startNum)

Finds the starting position of one text string within another text string. FINDB is case-sensitive. Use with double-byte character sets (DBCS).

``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>;``

#### Parameters

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

Is the text you want to find.

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

Is the text containing the text you want to find.

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

Specifies the character at which to start the search.

#### Returns

FunctionResult<number>

### fisher(x)

Returns the Fisher transformation.

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

#### Parameters

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

Is the value for which you want the transformation, a number between -1 and 1, excluding -1 and 1.

#### Returns

FunctionResult<number>

### fisherInv(y)

Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x.

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

#### Parameters

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

Is the value for which you want to perform the inverse of the transformation.

#### Returns

FunctionResult<number>

### fixed(number, decimals, noCommas)

Rounds a number to the specified number of decimals and returns the result as text with or without commas.

``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>;``

#### Parameters

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

Is the number you want to round and convert to text.

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

Is the number of digits to the right of the decimal point. If omitted, Decimals = 2.

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

Is a logical value: do not display commas in the returned text = TRUE; do display commas in the returned text = FALSE or omitted.

#### Returns

FunctionResult<string>

### floor_Math(number, significance, mode)

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

``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>;``

#### Parameters

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

Is the value you want to round.

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

Is the multiple to which you want to round.

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

When given and nonzero this function will round towards zero.

#### Returns

FunctionResult<number>

### floor_Precise(number, significance)

Rounds a number down, to the nearest integer or to the nearest multiple of significance.

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

#### Parameters

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

Is the numeric value you want to round.

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

Is the multiple to which you want to round.

#### Returns

FunctionResult<number>

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

Returns the future value of an investment based on periodic, constant payments and a constant interest rate.

``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>;``

#### Parameters

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

Is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

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

Is the total number of payment periods in the investment.

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

Is the payment made each period; it cannot change over the life of the investment.

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

Is the present value, or the lump-sum amount that a series of future payments is worth now. If omitted, Pv = 0.

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

Is a value representing the timing of payment: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.

#### Returns

FunctionResult<number>

### fvschedule(principal, schedule)

Returns the future value of an initial principal after applying a series of compound interest rates.

``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>;``

#### Parameters

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

Is the present value.

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

Is an array of interest rates to apply.

#### Returns

FunctionResult<number>

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

Returns the gamma distribution.

``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>;``

#### Parameters

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

Is the value at which you want to evaluate the distribution, a nonnegative number.

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

Is a parameter to the distribution, a positive number.

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

Is a parameter to the distribution, a positive number. If beta = 1, GAMMA.DIST returns the standard gamma distribution.

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

Is a logical value: return the cumulative distribution function = TRUE; return the probability mass function = FALSE or omitted.

#### Returns

FunctionResult<number>

### gamma_Inv(probability, alpha, beta)

Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x.

``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>;``

#### Parameters

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

Is the probability associated with the gamma distribution, a number between 0 and 1, inclusive.

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

Is a parameter to the distribution, a positive number.

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

Is a parameter to the distribution, a positive number. If beta = 1, GAMMA.INV returns the inverse of the standard gamma distribution.

#### Returns

FunctionResult<number>

### gamma(x)

Returns the Gamma function value.

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

#### Parameters

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

Is the value for which you want to calculate Gamma.

#### Returns

FunctionResult<number>

### gammaLn_Precise(x)

Returns the natural logarithm of the gamma function.

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

#### Parameters

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

Is the value for which you want to calculate GAMMALN.PRECISE, a positive number.

#### Returns

FunctionResult<number>

### gammaLn(x)

Returns the natural logarithm of the gamma function.

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

#### Parameters

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

Is the value for which you want to calculate GAMMALN, a positive number.

#### Returns

FunctionResult<number>

### gauss(x)

Returns 0.5 less than the standard normal cumulative distribution.

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

#### Parameters

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

Is the value for which you want the distribution.

#### Returns

FunctionResult<number>

### gcd(values)

Returns the greatest common divisor.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 values.

#### Returns

FunctionResult<number>

### geoMean(values)

Returns the geometric mean of an array or range of positive numeric data.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the mean.

#### Returns

FunctionResult<number>

### geStep(number, step)

Tests whether a number is greater than a threshold value.

``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>;``

#### Parameters

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

Is the value to test against step.

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

Is the threshold value.

#### Returns

FunctionResult<number>

### harMean(values)

Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the harmonic mean.

#### Returns

FunctionResult<number>

### hex2Bin(number, places)

Converts a Hexadecimal number to binary.

``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>;``

#### Parameters

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

Is the hexadecimal number you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### hex2Dec(number)

Converts a hexadecimal number to decimal.

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

#### Parameters

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

Is the hexadecimal number you want to convert.

#### Returns

FunctionResult<number>

### hex2Oct(number, places)

Converts a hexadecimal number to octal.

``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>;``

#### Parameters

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

Is the hexadecimal number you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### 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.

``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>;``

#### Parameters

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

Is the value to be found in the first row of the table and can be a value, a reference, or a text string.

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

Is a table of text, numbers, or logical values in which data is looked up. tableArray can be a reference to a range or a range name.

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

Is the row number in tableArray from which the matching value should be returned. The first row of values in the table is row 1.

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

Is a logical value: to find the closest match in the top row (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE.

#### Returns

FunctionResult<number | string | boolean>

### hour(serialNumber)

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

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

#### Parameters

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

Is a number in the date-time code used by Microsoft Excel, or text in time format, such as 16:48:00 or 4:48:00 PM.

#### Returns

FunctionResult<number>

Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet.

``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>;``

#### Parameters

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

Is the text giving the path and file name to the document to be opened, a hard drive location, UNC address, or URL path.

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

Is text or a number that is displayed in the cell. If omitted, the cell displays the linkLocation text.

#### Returns

FunctionResult<number | string | boolean>

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

Returns the hypergeometric distribution.

``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>;``

#### Parameters

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

Is the number of successes in the sample.

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

Is the size of the sample.

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

Is the number of successes in the population.

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

Is the population size.

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

Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.

#### Returns

FunctionResult<number>

### if(logicalTest, valueIfTrue, valueIfFalse)

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

``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>;``

#### Parameters

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

Is any value or expression that can be evaluated to TRUE or FALSE.

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

Is the value that is returned if logicalTest is TRUE. If omitted, TRUE is returned. You can nest up to seven IF functions.

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

Is the value that is returned if logicalTest is FALSE. If omitted, FALSE is returned.

#### Returns

FunctionResult<number | string | boolean>

### imAbs(inumber)

Returns the absolute value (modulus) of a complex number.

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

#### Parameters

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

Is a complex number for which you want the absolute value.

#### Returns

FunctionResult<number>

### imaginary(inumber)

Returns the imaginary coefficient of a complex number.

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

#### Parameters

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

Is a complex number for which you want the imaginary coefficient.

#### Returns

FunctionResult<number>

### imArgument(inumber)

Returns the argument q, an angle expressed in radians.

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

#### Parameters

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

Is a complex number for which you want the argument.

#### Returns

FunctionResult<number>

### imConjugate(inumber)

Returns the complex conjugate of a complex number.

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

#### Parameters

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

Is a complex number for which you want the conjugate.

#### Returns

FunctionResult<number>

### imCos(inumber)

Returns the cosine of a complex number.

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

#### Parameters

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

Is a complex number for which you want the cosine.

#### Returns

FunctionResult<number>

### imCosh(inumber)

Returns the hyperbolic cosine of a complex number.

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

#### Parameters

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

Is a complex number for which you want the hyperbolic cosine.

#### Returns

FunctionResult<number>

### imCot(inumber)

Returns the cotangent of a complex number.

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

#### Parameters

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

Is a complex number for which you want the cotangent.

#### Returns

FunctionResult<number>

### imCsc(inumber)

Returns the cosecant of a complex number.

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

#### Parameters

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

Is a complex number for which you want the cosecant.

#### Returns

FunctionResult<number>

### imCsch(inumber)

Returns the hyperbolic cosecant of a complex number.

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

#### Parameters

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

Is a complex number for which you want the hyperbolic cosecant.

#### Returns

FunctionResult<number>

### imDiv(inumber1, inumber2)

Returns the quotient of two complex numbers.

``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>;``

#### Parameters

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

Is the complex numerator or dividend.

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

Is the complex denominator or divisor.

#### Returns

FunctionResult<number>

### imExp(inumber)

Returns the exponential of a complex number.

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

#### Parameters

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

Is a complex number for which you want the exponential.

#### Returns

FunctionResult<number>

### imLn(inumber)

Returns the natural logarithm of a complex number.

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

#### Parameters

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

Is a complex number for which you want the natural logarithm.

#### Returns

FunctionResult<number>

### imLog10(inumber)

Returns the base-10 logarithm of a complex number.

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

#### Parameters

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

Is a complex number for which you want the common logarithm.

#### Returns

FunctionResult<number>

### imLog2(inumber)

Returns the base-2 logarithm of a complex number.

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

#### Parameters

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

Is a complex number for which you want the base-2 logarithm.

#### Returns

FunctionResult<number>

### imPower(inumber, number)

Returns a complex number raised to an integer power.

``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>;``

#### Parameters

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

Is a complex number you want to raise to a power.

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

Is the power to which you want to raise the complex number.

#### Returns

FunctionResult<number>

### imProduct(values)

Returns the product of 1 to 255 complex numbers.

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

#### Parameters

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

Inumber1, Inumber2,... are from 1 to 255 complex numbers to multiply.

#### Returns

FunctionResult<number>

### imReal(inumber)

Returns the real coefficient of a complex number.

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

#### Parameters

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

Is a complex number for which you want the real coefficient.

#### Returns

FunctionResult<number>

### imSec(inumber)

Returns the secant of a complex number.

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

#### Parameters

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

Is a complex number for which you want the secant.

#### Returns

FunctionResult<number>

### imSech(inumber)

Returns the hyperbolic secant of a complex number.

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

#### Parameters

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

Is a complex number for which you want the hyperbolic secant.

#### Returns

FunctionResult<number>

### imSin(inumber)

Returns the sine of a complex number.

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

#### Parameters

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

Is a complex number for which you want the sine.

#### Returns

FunctionResult<number>

### imSinh(inumber)

Returns the hyperbolic sine of a complex number.

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

#### Parameters

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

Is a complex number for which you want the hyperbolic sine.

#### Returns

FunctionResult<number>

### imSqrt(inumber)

Returns the square root of a complex number.

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

#### Parameters

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

Is a complex number for which you want the square root.

#### Returns

FunctionResult<number>

### imSub(inumber1, inumber2)

Returns the difference of two complex numbers.

``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>;``

#### Parameters

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

Is the complex number from which to subtract inumber2.

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

Is the complex number to subtract from inumber1.

#### Returns

FunctionResult<number>

### imSum(values)

Returns the sum of complex numbers.

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

#### Parameters

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

List of parameters, whose elements are from 1 to 255 complex numbers to add.

#### Returns

FunctionResult<number>

### imTan(inumber)

Returns the tangent of a complex number.

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

#### Parameters

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

Is a complex number for which you want the tangent.

#### Returns

FunctionResult<number>

### int(number)

Rounds a number down to the nearest integer.

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

#### Parameters

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

Is the real number you want to round down to an integer.

#### Returns

FunctionResult<number>

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

Returns the interest rate for a fully invested security.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the amount invested in the security.

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

Is the amount to be received at maturity.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### 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.

``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>;``

#### Parameters

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

Is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

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

Is the period for which you want to find the interest and must be in the range 1 to Nper.

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

Is the total number of payment periods in an investment.

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

Is the present value, or the lump-sum amount that a series of future payments is worth now.

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

Is the future value, or a cash balance you want to attain after the last payment is made. If omitted, Fv = 0.

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

Is a logical value representing the timing of payment: at the end of the period = 0 or omitted, at the beginning of the period = 1.

#### Returns

FunctionResult<number>

### irr(values, guess)

Returns the internal rate of return for a series of cash flows.

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

#### Parameters

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

Is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

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

Is a number that you guess is close to the result of IRR; 0.1 (10 percent) if omitted.

#### Returns

FunctionResult<number>

### isErr(value)

Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### isError(value)

Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### isEven(number)

Returns TRUE if the number is even.

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

#### Parameters

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

Is the value to test.

#### Returns

FunctionResult<number>

### isFormula(reference)

Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE.

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

#### Parameters

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

Is a reference to the cell you want to test. Reference can be a cell reference, a formula, or name that refers to a cell.

#### Returns

FunctionResult<boolean>

### isLogical(value)

Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### isNA(value)

Checks whether a value is #N/A, and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### isNonText(value)

Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want tested: a cell; a formula; or a name referring to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### isNumber(value)

Checks whether a value is a number, and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### iso_Ceiling(number, significance)

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

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

#### Parameters

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

Is the value you want to round.

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

Is the optional multiple to which you want to round.

#### Returns

FunctionResult<number>

### isOdd(number)

Returns TRUE if the number is odd.

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

#### Parameters

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

Is the value to test.

#### Returns

FunctionResult<number>

### isoWeekNum(date)

Returns the ISO week number in the year for a given date.

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

#### Parameters

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

Is the date-time code used by Microsoft Excel for date and time calculation.

#### Returns

FunctionResult<number>

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

Returns the interest paid during a specific period of an investment.

``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>;``

#### Parameters

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

Interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

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

Period for which you want to find the interest.

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

Number of payment periods in an investment.

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

Lump sum amount that a series of future payments is right now.

#### Returns

FunctionResult<number>

### isref(value)

Checks whether a value is a reference, and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### isText(value)

Checks whether a value is text, and returns TRUE or FALSE.

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

#### Parameters

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

Is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.

#### Returns

FunctionResult<boolean>

### kurt(values)

Returns the kurtosis of a data set.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the kurtosis.

#### Returns

FunctionResult<number>

### large(array, k)

Returns the k-th largest value in a data set. For example, the fifth largest number.

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

#### Parameters

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

Is the array or range of data for which you want to determine the k-th largest value.

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

Is the position (from the largest) in the array or cell range of the value to return.

#### Returns

FunctionResult<number>

### lcm(values)

Returns the least common multiple.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 values for which you want the least common multiple.

#### Returns

FunctionResult<number>

### left(text, numChars)

Returns the specified number of characters from the start of a text string.

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

#### Parameters

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

Is the text string containing the characters you want to extract.

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

Specifies how many characters you want LEFT to extract; 1 if omitted.

#### Returns

FunctionResult<string>

### leftb(text, numBytes)

Returns the specified number of characters from the start of a text string. Use with double-byte character sets (DBCS).

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

#### Parameters

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

Is the text string containing the characters you want to extract.

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

Specifies how many characters you want LEFT to return.

#### Returns

FunctionResult<string>

### len(text)

Returns the number of characters in a text string.

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

#### Parameters

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

Is the text whose length you want to find. Spaces count as characters.

#### Returns

FunctionResult<number>

### lenb(text)

Returns the number of characters in a text string. Use with double-byte character sets (DBCS).

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

#### Parameters

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

Is the text whose length you want to find.

#### Returns

FunctionResult<number>

### ln(number)

Returns the natural logarithm of a number.

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

#### Parameters

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

Is the positive real number for which you want the natural logarithm.

#### Returns

FunctionResult<number>

### log(number, base)

Returns the logarithm of a number to the base you specify.

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

#### Parameters

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

Is the positive real number for which you want the logarithm.

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

Is the base of the logarithm; 10 if omitted.

#### Returns

FunctionResult<number>

### log10(number)

Returns the base-10 logarithm of a number.

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

#### Parameters

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

Is the positive real number for which you want the base-10 logarithm.

#### Returns

FunctionResult<number>

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

Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.

``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>;``

#### Parameters

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

Is the value at which to evaluate the function, a positive number.

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

Is the mean of ln(x).

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

Is the standard deviation of ln(x), a positive number.

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

Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.

#### Returns

FunctionResult<number>

### logNorm_Inv(probability, mean, standardDev)

Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev.

``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>;``

#### Parameters

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

Is a probability associated with the lognormal distribution, a number between 0 and 1, inclusive.

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

Is the mean of ln(x).

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

Is the standard deviation of ln(x), a positive number.

#### Returns

FunctionResult<number>

### 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.

``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>;``

#### Parameters

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

Is a value that LOOKUP searches for in lookupVector and can be a number, text, a logical value, or a name or reference to a value.

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

Is a range that contains only one row or one column of text, numbers, or logical values, placed in ascending order.

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

Is a range that contains only one row or column, the same size as lookupVector.

#### Returns

FunctionResult<number | string | boolean>

### lower(text)

Converts all letters in a text string to lowercase.

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

#### Parameters

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

Is the text you want to convert to lowercase. Characters in Text that are not letters are not changed.

#### Returns

FunctionResult<string>

### match(lookupValue, lookupArray, matchType)

Returns the relative position of an item in an array that matches a specified value in a specified order.

``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>;``

#### Parameters

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

Is the value you use to find the value you want in the array, a number, text, or logical value, or a reference to one of these.

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

Is a contiguous range of cells containing possible lookup values, an array of values, or a reference to an array.

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

Is a number 1, 0, or -1 indicating which value to return.

#### Returns

FunctionResult<number>

### max(values)

Returns the largest value in a set of values. Ignores logical values and text.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the maximum.

#### Returns

FunctionResult<number>

### maxA(values)

Returns the largest value in a set of values. Does not ignore logical values and text.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the maximum.

#### Returns

FunctionResult<number>

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

Returns the Macauley modified duration for a security with an assumed par value of \$100.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's annual coupon rate.

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

Is the security's annual yield.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### median(values)

Returns the median, or the number in the middle of the set of given numbers.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the median.

#### Returns

FunctionResult<number>

### mid(text, startNum, numChars)

Returns the characters from the middle of a text string, given a starting position and length.

``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>;``

#### Parameters

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

Is the text string from which you want to extract the characters.

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

Is the position of the first character you want to extract. The first character in Text is 1.

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

Specifies how many characters to return from Text.

#### Returns

FunctionResult<string>

### midb(text, startNum, numBytes)

Returns characters from the middle of a text string, given a starting position and length. Use with double-byte character sets (DBCS).

``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>;``

#### Parameters

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

Is the text string containing the characters you want to extract.

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

Is the position of the first character you want to extract in text.

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

Specifies how many characters to return from text.

#### Returns

FunctionResult<string>

### min(values)

Returns the smallest number in a set of values. Ignores logical values and text.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the minimum.

#### Returns

FunctionResult<number>

### minA(values)

Returns the smallest value in a set of values. Does not ignore logical values and text.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the minimum.

#### Returns

FunctionResult<number>

### minute(serialNumber)

Returns the minute, a number from 0 to 59.

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

#### Parameters

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

Is a number in the date-time code used by Microsoft Excel or text in time format, such as 16:48:00 or 4:48:00 PM.

#### Returns

FunctionResult<number>

### 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.

``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>;``

#### Parameters

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

Is an array or a reference to cells that contain numbers that represent a series of payments (negative) and income (positive) at regular periods.

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

Is the interest rate you pay on the money used in the cash flows.

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

Is the interest rate you receive on the cash flows as you reinvest them.

#### Returns

FunctionResult<number>

### mod(number, divisor)

Returns the remainder after a number is divided by a divisor.

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

#### Parameters

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

Is the number for which you want to find the remainder after the division is performed.

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

Is the number by which you want to divide Number.

#### Returns

FunctionResult<number>

### month(serialNumber)

Returns the month, a number from 1 (January) to 12 (December).

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

#### Parameters

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

Is a number in the date-time code used by Microsoft Excel.

#### Returns

FunctionResult<number>

### mround(number, multiple)

Returns a number rounded to the desired 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>;``

#### Parameters

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

Is the value to round.

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

Is the multiple to which you want to round number.

#### Returns

FunctionResult<number>

### multiNomial(values)

Returns the multinomial of a set of numbers.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 values for which you want the multinomial.

#### Returns

FunctionResult<number>

### n(value)

Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero).

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

#### Parameters

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

Is the value you want converted.

#### Returns

FunctionResult<number>

### na()

Returns the error value #N/A (value not available).

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

#### Returns

FunctionResult<number | string>

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

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.

``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>;``

#### Parameters

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

Is the number of failures.

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

Is the threshold number of successes.

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

Is the probability of a success; a number between 0 and 1.

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

Is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.

#### Returns

FunctionResult<number>

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

Returns the number of whole workdays between two dates with custom weekend parameters.

``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>;``

#### Parameters

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

Is a serial date number that represents the start date.

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

Is a serial date number that represents the end date.

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

Is a number or string specifying when weekends occur.

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

Is an optional set of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays.

#### Returns

FunctionResult<number>

### networkDays(startDate, endDate, holidays)

Returns the number of whole workdays between two dates.

``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>;``

#### Parameters

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

Is a serial date number that represents the start date.

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

Is a serial date number that represents the end date.

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

Is an optional set of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays.

#### Returns

FunctionResult<number>

### nominal(effectRate, npery)

Returns the annual nominal interest rate.

``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>;``

#### Parameters

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

Is the effective interest rate.

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

Is the number of compounding periods per year.

#### Returns

FunctionResult<number>

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

Returns the normal distribution for the specified mean and standard deviation.

``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>;``

#### Parameters

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

Is the value for which you want the distribution.

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

Is the arithmetic mean of the distribution.

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

Is the standard deviation of the distribution, a positive number.

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

Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.

#### Returns

FunctionResult<number>

### norm_Inv(probability, mean, standardDev)

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

``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>;``

#### Parameters

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

Is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive.

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

Is the arithmetic mean of the distribution.

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

Is the standard deviation of the distribution, a positive number.

#### Returns

FunctionResult<number>

### norm_S_Dist(z, cumulative)

Returns the standard normal distribution (has a mean of zero and a standard deviation of one).

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

#### Parameters

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

Is the value for which you want the distribution.

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

Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.

#### Returns

FunctionResult<number>

### norm_S_Inv(probability)

Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one).

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

#### Parameters

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

Is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive.

#### Returns

FunctionResult<number>

### not(logical)

Changes FALSE to TRUE, or TRUE to FALSE.

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

#### Parameters

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

Is a value or expression that can be evaluated to TRUE or FALSE.

#### Returns

FunctionResult<boolean>

### now()

Returns the current date and time formatted as a date and time.

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

#### Returns

FunctionResult<number>

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

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

``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>;``

#### Parameters

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

Is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

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

Is the payment made each period; it cannot change over the life of the investment.

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

Is the present value, or the lump-sum amount that a series of future payments is worth now.

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

Is the future value, or a cash balance you want to attain after the last payment is made. If omitted, zero is used.

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

Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.

#### Returns

FunctionResult<number>

### 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).

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

#### Parameters

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

Is the rate of discount over the length of one period.

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

List of parameters, whose elements are 1 to 254 payments and income, equally spaced in time and occurring at the end of each period.

#### Returns

FunctionResult<number>

### numberValue(text, decimalSeparator, groupSeparator)

Converts text to number in a locale-independent manner.

``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>;``

#### Parameters

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

Is the string representing the number you want to convert.

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

Is the character used as the decimal separator in the string.

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

Is the character used as the group separator in the string.

#### Returns

FunctionResult<number>

### oct2Bin(number, places)

Converts an octal number to binary.

``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>;``

#### Parameters

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

Is the octal number you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### oct2Dec(number)

Converts an octal number to decimal.

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

#### Parameters

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

Is the octal number you want to convert.

#### Returns

FunctionResult<number>

### oct2Hex(number, places)

Converts an octal number to hexadecimal.

``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>;``

#### Parameters

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

Is the octal number you want to convert.

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

Is the number of characters to use.

#### Returns

FunctionResult<number>

### odd(number)

Rounds a positive number up and negative number down to the nearest odd integer.

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

#### Parameters

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

Is the value to round.

#### Returns

FunctionResult<number>

### oddFPrice(settlement, maturity, issue, firstCoupon, rate, yld, redemption, frequency, basis)

Returns the price per \$100 face value of a security with an odd first period.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's issue date, expressed as a serial date number.

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

Is the security's first coupon date, expressed as a serial date number.

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

Is the security's interest rate.

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

Is the security's annual yield.

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

Is the security's redemption value per \$100 face value.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### oddFYield(settlement, maturity, issue, firstCoupon, rate, pr, redemption, frequency, basis)

Returns the yield of a security with an odd first period.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's issue date, expressed as a serial date number.

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

Is the security's first coupon date, expressed as a serial date number.

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

Is the security's interest rate.

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

Is the security's price.

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

Is the security's redemption value per \$100 face value.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### oddLPrice(settlement, maturity, lastInterest, rate, yld, redemption, frequency, basis)

Returns the price per \$100 face value of a security with an odd last period.

``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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's last coupon date, expressed as a serial date number.

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

Is the security's interest rate.

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

Is the security's annual yield.

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

Is the security's redemption value per \$100 face value.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### oddLYield(settlement, maturity, lastInterest, rate, pr, redemption, frequency, basis)

Returns the yield of a security with an odd last period.

``oddLYield(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>, 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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's last coupon date, expressed as a serial date number.

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

Is the security's interest rate.

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

Is the security's price.

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

Is the security's redemption value per \$100 face value.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### or(values)

Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 conditions that you want to test that can be either TRUE or FALSE.

#### Returns

FunctionResult<boolean>

### pduration(rate, pv, fv)

Returns the number of periods required by an investment to reach a specified value.

``pduration(rate: 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>): FunctionResult<number>;``

#### Parameters

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

Is the interest rate per period.

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

Is the present value of the investment.

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

Is the desired future value of the investment.

#### Returns

FunctionResult<number>

### percentile_Exc(array, k)

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

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

#### Parameters

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

Is the array or range of data that defines relative standing.

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

Is the percentile value that is between 0 through 1, inclusive.

#### Returns

FunctionResult<number>

### percentile_Inc(array, k)

Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.

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

#### Parameters

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

Is the array or range of data that defines relative standing.

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

Is the percentile value that is between 0 through 1, inclusive.

#### Returns

FunctionResult<number>

### percentRank_Exc(array, x, significance)

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_Exc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

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

Is the array or range of data with numeric values that defines relative standing.

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

Is the value for which you want to know the rank.

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

Is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%).

#### Returns

FunctionResult<number>

### percentRank_Inc(array, x, significance)

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.

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

#### Parameters

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

Is the array or range of data with numeric values that defines relative standing.

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

Is the value for which you want to know the rank.

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

Is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%).

#### Returns

FunctionResult<number>

### permut(number, numberChosen)

Returns the number of permutations for a given number of objects that can be selected from the total objects.

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

#### Parameters

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

Is the total number of objects.

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

Is the number of objects in each permutation.

#### Returns

FunctionResult<number>

### permutationa(number, numberChosen)

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

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

#### Parameters

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

Is the total number of objects.

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

Is the number of objects in each permutation.

#### Returns

FunctionResult<number>

### phi(x)

Returns the value of the density function for a standard normal distribution.

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

#### Parameters

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

Is the number for which you want the density of the standard normal distribution.

#### Returns

FunctionResult<number>

### pi()

Returns the value of Pi, 3.14159265358979, accurate to 15 digits.

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

#### Returns

FunctionResult<number>

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

Calculates the payment for a loan based on constant payments and a constant interest rate.

``pmt(rate: 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>;``

#### Parameters

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

Is the interest rate per period for the loan. For example, use 6%/4 for quarterly payments at 6% APR.

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

Is the total number of payments for the loan.

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

Is the present value: the total amount that a series of future payments is worth now.

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

Is the future value, or a cash balance you want to attain after the last payment is made, 0 (zero) if omitted.

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

Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.

#### Returns

FunctionResult<number>

### poisson_Dist(x, mean, cumulative)

Returns the Poisson distribution.

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

#### Parameters

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

Is the number of events.

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

Is the expected numeric value, a positive number.

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

Is a logical value: for the cumulative Poisson probability, use TRUE; for the Poisson probability mass function, use FALSE.

#### Returns

FunctionResult<number>

### power(number, power)

Returns the result of a number raised to a power.

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

#### Parameters

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

Is the base number, any real number.

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

Is the exponent, to which the base number is raised.

#### Returns

FunctionResult<number>

### 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.

``ppmt(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>;``

#### Parameters

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

Is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

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

Specifies the period and must be in the range 1 to nper.

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

Is the total number of payment periods in an investment.

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

Is the present value: the total amount that a series of future payments is worth now.

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

Is the future value, or cash balance you want to attain after the last payment is made.

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

Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.

#### Returns

FunctionResult<number>

### price(settlement, maturity, rate, yld, redemption, frequency, basis)

Returns the price per \$100 face value of a security that pays periodic interest.

``price(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: 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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's annual coupon rate.

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

Is the security's annual yield.

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

Is the security's redemption value per \$100 face value.

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

Is the number of coupon payments per year.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### priceDisc(settlement, maturity, discount, redemption, basis)

Returns the price per \$100 face value of a discounted security.

``priceDisc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, discount: 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>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's discount rate.

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

Is the security's redemption value per \$100 face value.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### priceMat(settlement, maturity, issue, rate, yld, basis)

Returns the price per \$100 face value of a security that pays interest at maturity.

``priceMat(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>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

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

Is the security's settlement date, expressed as a serial date number.

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

Is the security's maturity date, expressed as a serial date number.

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

Is the security's issue date, expressed as a serial date number.

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

Is the security's interest rate at date of issue.

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

Is the security's annual yield.

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

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### product(values)

Multiplies all the numbers given as arguments.

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

#### Parameters

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

List of parameters, whose elements are 1 to 255 numbers, logical values, or text representations of numbers that you want to multiply.

#### Returns

FunctionResult<number>

### proper(text)

Converts a text string to proper case; the first letter in each word to uppercase, and all other letters to lowercase.

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

#### Parameters

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

Is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing text to partially capitalize.

#### Returns

FunctionResult<string>

### 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.

``pv(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>, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

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

Is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

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

Is the total number of payment periods in an investment.

pmt
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the payment made each period and cannot change over the life of the investment.

fv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the future value, or a cash balance you want to attain after the last payment is made.

type
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.

#### Returns

FunctionResult<number>

### quartile_Exc(array, quart)

Returns the quartile of a data set, based on percentile values from 0..1, exclusive.

``quartile_Exc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, quart: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

array
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the array or cell range of numeric values for which you want the quartile value.

quart
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4.

#### Returns

FunctionResult<number>

### quartile_Inc(array, quart)

Returns the quartile of a data set, based on percentile values from 0..1, inclusive.

``quartile_Inc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, quart: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

array
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the array or cell range of numeric values for which you want the quartile value.

quart
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4.

#### Returns

FunctionResult<number>

### quotient(numerator, denominator)

Returns the integer portion of a division.

``quotient(numerator: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, denominator: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

numerator
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the dividend.

denominator
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the divisor.

#### Returns

FunctionResult<number>

``radians(angle: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

angle
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an angle in degrees that you want to convert.

#### Returns

FunctionResult<number>

### rand()

Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).

``rand(): FunctionResult<number>;``

#### Returns

FunctionResult<number>

### randBetween(bottom, top)

Returns a random number between the numbers you specify.

``randBetween(bottom: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, top: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

bottom
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the smallest integer RANDBETWEEN will return.

top
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the largest integer RANDBETWEEN will return.

#### Returns

FunctionResult<number>

### 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_Avg(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ref: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, order?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number for which you want to find the rank.

ref
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored.

order
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value.

#### Returns

FunctionResult<number>

### 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.

``rank_Eq(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ref: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, order?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number for which you want to find the rank.

ref
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored.

order
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value.

#### Returns

FunctionResult<number>

### rate(nper, pmt, pv, fv, type, guess)

Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR.

``rate(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>, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, guess?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

nper
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the total number of payment periods for the loan or investment.

pmt
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the payment made each period and cannot change over the life of the loan or investment.

pv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the present value: the total amount that a series of future payments is worth now.

fv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the future value, or a cash balance you want to attain after the last payment is made. If omitted, uses Fv = 0.

type
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.

guess
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is your guess for what the rate will be; if omitted, Guess = 0.1 (10 percent).

#### Returns

FunctionResult<number>

### received(settlement, maturity, investment, discount, basis)

Returns the amount received at maturity for a fully invested security.

``received(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>, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's maturity date, expressed as a serial date number.

investment
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the amount invested in the security.

discount
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's discount rate.

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### replace(oldText, startNum, numChars, newText)

Replaces part of a text string with a different text string.

``replace(oldText: 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>, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

oldText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is text in which you want to replace some characters.

startNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the position of the character in oldText that you want to replace with newText.

numChars
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of characters in oldText that you want to replace.

newText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text that will replace characters in oldText.

#### Returns

FunctionResult<string>

### replaceB(oldText, startNum, numBytes, newText)

Replaces part of a text string with a different text string. Use with double-byte character sets (DBCS).

``replaceB(oldText: 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>, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

oldText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is text in which you want to replace some characters.

startNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the position of the character in oldText that you want to replace with newText.

numBytes
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of characters in oldText that you want to replace with newText.

newText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text that will replace characters in oldText.

#### Returns

FunctionResult<string>

### rept(text, numberTimes)

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

``rept(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numberTimes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text you want to repeat.

numberTimes
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a positive number specifying the number of times to repeat text.

#### Returns

FunctionResult<string>

### right(text, numChars)

Returns the specified number of characters from the end of a text string.

``right(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numChars?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text string that contains the characters you want to extract.

numChars
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Specifies how many characters you want to extract, 1 if omitted.

#### Returns

FunctionResult<string>

### rightb(text, numBytes)

Returns the specified number of characters from the end of a text string. Use with double-byte character sets (DBCS).

``rightb(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numBytes?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text string containing the characters you want to extract.

numBytes
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Specifies how many characters you want to extract.

#### Returns

FunctionResult<string>

### roman(number, form)

Converts an Arabic numeral to Roman, as text.

``roman(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, form?: boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Arabic numeral you want to convert.

form
boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number specifying the type of Roman numeral you want.

#### Returns

FunctionResult<string>

### round(number, numDigits)

Rounds a number to a specified number of digits.

``round(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number you want to round.

numDigits
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer.

#### Returns

FunctionResult<number>

### roundDown(number, numDigits)

Rounds a number down, toward zero.

``roundDown(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is any real number that you want rounded down.

numDigits
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero or omitted, to the nearest integer.

#### Returns

FunctionResult<number>

### roundUp(number, numDigits)

Rounds a number up, away from zero.

``roundUp(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is any real number that you want rounded up.

numDigits
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero or omitted, to the nearest integer.

#### Returns

FunctionResult<number>

### rows(array)

Returns the number of rows in a reference or array.

``rows(array: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

array
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an array, an array formula, or a reference to a range of cells for which you want the number of rows.

#### Returns

FunctionResult<number>

### rri(nper, pv, fv)

Returns an equivalent interest rate for the growth of an investment.

``rri(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>): FunctionResult<number>;``

#### Parameters

nper
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of periods for the investment.

pv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the present value of the investment.

fv
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the future value of the investment.

#### Returns

FunctionResult<number>

### sec(number)

Returns the secant of an angle.

``sec(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the angle in radians for which you want the secant.

#### Returns

FunctionResult<number>

### sech(number)

Returns the hyperbolic secant of an angle.

``sech(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the angle in radians for which you want the hyperbolic secant.

#### Returns

FunctionResult<number>

### second(serialNumber)

Returns the second, a number from 0 to 59.

``second(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number in the date-time code used by Microsoft Excel or text in time format, such as 16:48:23 or 4:48:47 PM.

#### Returns

FunctionResult<number>

### seriesSum(x, n, m, coefficients)

Returns the sum of a power series based on the formula.

``seriesSum(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, m: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, coefficients: Excel.Range | string | number | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

x
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the input value to the power series.

n
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the initial power to which you want to raise x.

m
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the step by which to increase n for each term in the series.

coefficients
Excel.Range | string | number | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is a set of coefficients by which each successive power of x is multiplied.

#### Returns

FunctionResult<number>

### sheet(value)

Returns the sheet number of the referenced sheet.

``sheet(value?: Excel.Range | string | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

value
Excel.Range | string | Excel.RangeReference | Excel.FunctionResult<any>

Is the name of a sheet or a reference that you want the sheet number of. If omitted the number of the sheet containing the function is returned.

#### Returns

FunctionResult<number>

### sheets(reference)

Returns the number of sheets in a reference.

``sheets(reference?: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

reference
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a reference for which you want to know the number of sheets it contains. If omitted the number of sheets in the workbook containing the function is returned.

#### Returns

FunctionResult<number>

### sign(number)

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.

``sign(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is any real number.

#### Returns

FunctionResult<number>

### sin(number)

Returns the sine of an angle.

``sin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the angle in radians for which you want the sine. Degrees * PI()/180 = radians.

#### Returns

FunctionResult<number>

### sinh(number)

Returns the hyperbolic sine of a number.

``sinh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is any real number.

#### Returns

FunctionResult<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_p(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 254 numbers or names, arrays, or references that contain numbers for which you want the population skewness.

#### Returns

FunctionResult<number>

### skew(values)

Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean.

``skew(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numbers or names, arrays, or references that contain numbers for which you want the skewness.

#### Returns

FunctionResult<number>

### sln(cost, salvage, life)

Returns the straight-line depreciation of an asset for one period.

``sln(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>): FunctionResult<number>;``

#### Parameters

cost
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the initial cost of the asset.

salvage
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the salvage value at the end of the life of the asset.

life
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

#### Returns

FunctionResult<number>

### small(array, k)

Returns the k-th smallest value in a data set. For example, the fifth smallest number.

``small(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

array
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an array or range of numerical data for which you want to determine the k-th smallest value.

k
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the position (from the smallest) in the array or range of the value to return.

#### Returns

FunctionResult<number>

### sqrt(number)

Returns the square root of a number.

``sqrt(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number for which you want the square root.

#### Returns

FunctionResult<number>

### sqrtPi(number)

Returns the square root of (number * Pi).

``sqrtPi(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number by which p is multiplied.

#### Returns

FunctionResult<number>

### standardize(x, mean, standardDev)

Returns a normalized value from a distribution characterized by a mean and standard deviation.

``standardize(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>): FunctionResult<number>;``

#### Parameters

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the value you want to normalize.

mean
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the arithmetic mean of the distribution.

standardDev
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the standard deviation of the distribution, a positive number.

#### Returns

FunctionResult<number>

### stDev_P(values)

Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).

``stDev_P(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numbers corresponding to a population and can be numbers or references that contain numbers.

#### Returns

FunctionResult<number>

### stDev_S(values)

Estimates standard deviation based on a sample (ignores logical values and text in the sample).

``stDev_S(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numbers corresponding to a sample of a population and can be numbers or references that contain numbers.

#### Returns

FunctionResult<number>

### stDevA(values)

Estimates standard deviation based on a sample, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

``stDevA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 values corresponding to a sample of a population and can be values or names or references to values.

#### Returns

FunctionResult<number>

### stDevPA(values)

Calculates standard deviation based on an entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

``stDevPA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 values corresponding to a population and can be values, names, arrays, or references that contain values.

#### Returns

FunctionResult<number>

### substitute(text, oldText, newText, instanceNum)

Replaces existing text with new text in a text string.

``substitute(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, oldText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, instanceNum?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text or the reference to a cell containing text in which you want to substitute characters.

oldText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the existing text you want to replace. If the case of oldText does not match the case of text, SUBSTITUTE will not replace the text.

newText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text you want to replace oldText with.

instanceNum
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Specifies which occurrence of oldText you want to replace. If omitted, every instance of oldText is replaced.

#### Returns

FunctionResult<string>

### subtotal(functionNum, values)

Returns a subtotal in a list or database.

``subtotal(functionNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

functionNum
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number 1 to 11 that specifies the summary function for the subtotal.

values
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 254 ranges or references for which you want the subtotal.

#### Returns

FunctionResult<number>

### sum(values)

Adds all the numbers in a range of cells.

``sum(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numbers to sum. Logical values and text are ignored in cells, included if typed as arguments.

#### Returns

FunctionResult<number>

### sumIf(range, criteria, sumRange)

Adds the cells specified by a given condition or criteria.

``sumIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, sumRange?: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

range
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the range of cells you want evaluated.

criteria
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the condition or criteria in the form of a number, expression, or text that defines which cells will be added.

sumRange
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Are the actual cells to sum. If omitted, the cells in range are used.

#### Returns

FunctionResult<number>

### sumIfs(sumRange, values)

Adds the cells specified by a given set of conditions or criteria.

``sumIfs(sumRange: Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, ...values: Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> | number | string | boolean>): FunctionResult<number>;``

#### Parameters

sumRange
Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Are the actual cells to sum.

values
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult<any> | number | string | boolean>

List of parameters, where the first element of each pair is the Is the range of cells you want evaluated for the particular condition , and the second element is is the condition or criteria in the form of a number, expression, or text that defines which cells will be added.

#### Returns

FunctionResult<number>

### 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.

``sumSq(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numbers, arrays, names, or references to arrays for which you want the sum of the squares.

#### Returns

FunctionResult<number>

### syd(cost, salvage, life, per)

Returns the sum-of-years' digits depreciation of an asset for a specified period.

``syd(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>, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

cost
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the initial cost of the asset.

salvage
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the salvage value at the end of the life of the asset.

life
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

per
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the period and must use the same units as Life.

#### Returns

FunctionResult<number>

### t_Dist_2T(x, degFreedom)

Returns the two-tailed Student's t-distribution.

``t_Dist_2T(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the numeric value at which to evaluate the distribution.

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an integer indicating the number of degrees of freedom that characterize the distribution.

#### Returns

FunctionResult<number>

### t_Dist_RT(x, degFreedom)

Returns the right-tailed Student's t-distribution.

``t_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the numeric value at which to evaluate the distribution.

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an integer indicating the number of degrees of freedom that characterize the distribution.

#### Returns

FunctionResult<number>

### t_Dist(x, degFreedom, cumulative)

Returns the left-tailed Student's t-distribution.

``t_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>;``

#### Parameters

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the numeric value at which to evaluate the distribution.

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is an integer indicating the number of degrees of freedom that characterize the distribution.

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.

#### Returns

FunctionResult<number>

### t_Inv_2T(probability, degFreedom)

Returns the two-tailed inverse of the Student's t-distribution.

``t_Inv_2T(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the probability associated with the two-tailed Student's t-distribution, a number between 0 and 1 inclusive.

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a positive integer indicating the number of degrees of freedom to characterize the distribution.

#### Returns

FunctionResult<number>

### t_Inv(probability, degFreedom)

Returns the left-tailed inverse of the Student's t-distribution.

``t_Inv(probability: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

probability
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the probability associated with the two-tailed Student's t-distribution, a number between 0 and 1 inclusive.

degFreedom
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a positive integer indicating the number of degrees of freedom to characterize the distribution.

#### Returns

FunctionResult<number>

### 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.

``t(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the value to test.

#### Returns

FunctionResult<string>

### tan(number)

Returns the tangent of an angle.

``tan(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the angle in radians for which you want the tangent. Degrees * PI()/180 = radians.

#### Returns

FunctionResult<number>

### tanh(number)

Returns the hyperbolic tangent of a number.

``tanh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is any real number.

#### Returns

FunctionResult<number>

### tbillEq(settlement, maturity, discount)

Returns the bond-equivalent yield for a treasury bill.

``tbillEq(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's maturity date, expressed as a serial date number.

discount
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's discount rate.

#### Returns

FunctionResult<number>

### tbillPrice(settlement, maturity, discount)

Returns the price per \$100 face value for a treasury bill.

``tbillPrice(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's maturity date, expressed as a serial date number.

discount
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's discount rate.

#### Returns

FunctionResult<number>

### tbillYield(settlement, maturity, pr)

Returns the yield for a treasury bill.

``tbillYield(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>): FunctionResult<number>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury bill's maturity date, expressed as a serial date number.

pr
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Treasury Bill's price per \$100 face value.

#### Returns

FunctionResult<number>

### text(value, formatText)

Converts a value to text in a specific number format.

``text(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, formatText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

value
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.

formatText
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number format in text form from the Category box on the Number tab in the Format Cells dialog box (not General).

#### Returns

FunctionResult<string>

### time(hour, minute, second)

Converts hours, minutes, and seconds given as numbers to an Excel serial number, formatted with a time format.

``time(hour: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, minute: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, second: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

hour
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number from 0 to 23 representing the hour.

minute
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number from 0 to 59 representing the minute.

second
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number from 0 to 59 representing the second.

#### Returns

FunctionResult<number>

### timevalue(timeText)

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.

``timevalue(timeText: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

timeText
string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a text string that gives a time in any one of the Microsoft Excel time formats (date information in the string is ignored).

#### Returns

FunctionResult<number>

### today()

Returns the current date formatted as a date.

``today(): FunctionResult<number>;``

#### Returns

FunctionResult<number>

### toJSON()

Overrides the JavaScript `toJSON()` method in order to provide more useful output when an API object is passed to `JSON.stringify()`. (`JSON.stringify`, 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.

``````toJSON(): {
[key: string]: string;
};``````

#### Returns

{ [key: string]: string; }

### trim(text)

Removes all spaces from a text string except for single spaces between words.

``trim(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text from which you want spaces removed.

#### Returns

FunctionResult<string>

### trimMean(array, percent)

Returns the mean of the interior portion of a set of data values.

``trimMean(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, percent: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

array
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the range or array of values to trim and average.

percent
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the fractional number of data points to exclude from the top and bottom of the data set.

#### Returns

FunctionResult<number>

### true()

Returns the logical value TRUE.

``true(): FunctionResult<boolean>;``

#### Returns

FunctionResult<boolean>

### trunc(number, numDigits)

Truncates a number to an integer by removing the decimal, or fractional, part of the number.

``trunc(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, numDigits?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number you want to truncate.

numDigits
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number specifying the precision of the truncation, 0 (zero) if omitted.

#### Returns

FunctionResult<number>

### type(value)

Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64.

``type(value: boolean | string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

value
boolean | string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Can be any value.

#### Returns

FunctionResult<number>

### unichar(number)

Returns the Unicode character referenced by the given numeric value.

``unichar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the Unicode number representing a character.

#### Returns

FunctionResult<string>

### unicode(text)

Returns the number (code point) corresponding to the first character of the text.

``unicode(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the character that you want the Unicode value of.

#### Returns

FunctionResult<number>

### upper(text)

Converts a text string to all uppercase letters.

``upper(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

text
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text you want converted to uppercase, a reference or a text string.

#### Returns

FunctionResult<string>

### usdollar(number, decimals)

Converts a number to text, using currency format.

``usdollar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<string>;``

#### Parameters

number
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number, a reference to a cell containing a number, or a formula that evaluates to a number.

decimals
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of digits to the right of the decimal point.

#### Returns

FunctionResult<string>

### value(text)

Converts a text string that represents a number to a number.

``value(text: string | boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

text
string | boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

#### Returns

FunctionResult<number>

### var_P(values)

Calculates variance based on the entire population (ignores logical values and text in the population).

``var_P(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numeric arguments corresponding to a population.

#### Returns

FunctionResult<number>

### var_S(values)

Estimates variance based on a sample (ignores logical values and text in the sample).

``var_S(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 numeric arguments corresponding to a sample of a population.

#### Returns

FunctionResult<number>

### varA(values)

Estimates variance based on a sample, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

``varA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 value arguments corresponding to a sample of a population.

#### Returns

FunctionResult<number>

### varPA(values)

Calculates variance based on the entire population, including logical values and text. Text and the logical value FALSE have the value 0; the logical value TRUE has the value 1.

``varPA(...values: Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<number>;``

#### Parameters

values
Array<number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 255 value arguments corresponding to a population.

#### Returns

FunctionResult<number>

### 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.

``vdb(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>, startPeriod: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endPeriod: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, factor?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, noSwitch?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

cost
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the initial cost of the asset.

salvage
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the salvage value at the end of the life of the asset.

life
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

startPeriod
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the starting period for which you want to calculate the depreciation, in the same units as Life.

endPeriod
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the ending period for which you want to calculate the depreciation, in the same units as Life.

factor
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the rate at which the balance declines, 2 (double-declining balance) if omitted.

noSwitch
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Switch to straight-line depreciation when depreciation is greater than the declining balance = FALSE or omitted; do not switch = TRUE.

#### Returns

FunctionResult<number>

### 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.

``vlookup(lookupValue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, tableArray: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>, colIndexNum: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>, rangeLookup?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number | string | boolean>;``

#### Parameters

lookupValue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the value to be found in the first column of the table, and can be a value, a reference, or a text string.

tableArray
Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>

Is a table of text, numbers, or logical values, in which data is retrieved. tableArray can be a reference to a range or a range name.

colIndexNum
Excel.Range | number | Excel.RangeReference | Excel.FunctionResult<any>

Is the column number in tableArray from which the matching value should be returned. The first column of values in the table is column 1.

rangeLookup
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a logical value: to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE.

#### Returns

FunctionResult<number | string | boolean>

### weekday(serialNumber, returnType)

Returns a number from 1 to 7 identifying the day of the week of a date.

``weekday(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, returnType?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number that represents a date.

returnType
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number: for Sunday=1 through Saturday=7, use 1; for Monday=1 through Sunday=7, use 2; for Monday=0 through Sunday=6, use 3.

#### Returns

FunctionResult<number>

### weekNum(serialNumber, returnType)

Returns the week number in the year.

``weekNum(serialNumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, returnType?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

serialNumber
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the date-time code used by Microsoft Excel for date and time calculation.

returnType
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number (1 or 2) that determines the type of the return value.

#### Returns

FunctionResult<number>

### weibull_Dist(x, alpha, beta, cumulative)

Returns the Weibull distribution.

``weibull_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>;``

#### Parameters

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the value at which to evaluate the function, a nonnegative number.

alpha
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a parameter to the distribution, a positive number.

beta
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a parameter to the distribution, a positive number.

cumulative
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.

#### Returns

FunctionResult<number>

### 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_Intl(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, days: 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>;``

#### Parameters

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a serial date number that represents the start date.

days
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of nonweekend and non-holiday days before or after startDate.

weekend
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number or string specifying when weekends occur.

holidays
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is an optional array of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays.

#### Returns

FunctionResult<number>

### workDay(startDate, days, holidays)

Returns the serial number of the date before or after a specified number of workdays.

``workDay(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, days: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a serial date number that represents the start date.

days
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of nonweekend and non-holiday days before or after startDate.

holidays
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is an optional array of one or more serial date numbers to exclude from the working calendar, such as state and federal holidays and floating holidays.

#### Returns

FunctionResult<number>

### xirr(values, dates, guess)

Returns the internal rate of return for a schedule of cash flows.

``xirr(values: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>, dates: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>, guess?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

values
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is a series of cash flows that correspond to a schedule of payments in dates.

dates
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is a schedule of payment dates that corresponds to the cash flow payments.

guess
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number that you guess is close to the result of XIRR.

#### Returns

FunctionResult<number>

### xnpv(rate, values, dates)

Returns the net present value for a schedule of cash flows.

``xnpv(rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, values: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>, dates: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the discount rate to apply to the cash flows.

values
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is a series of cash flows that correspond to a schedule of payments in dates.

dates
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult<any>

Is a schedule of payment dates that corresponds to the cash flow payments.

#### Returns

FunctionResult<number>

### xor(values)

Returns a logical 'Exclusive Or' of all arguments.

``xor(...values: Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>): FunctionResult<boolean>;``

#### Parameters

values
Array<boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>>

List of parameters, whose elements are 1 to 254 conditions you want to test that can be either TRUE or FALSE and can be logical values, arrays, or references.

#### Returns

FunctionResult<boolean>

### year(serialNumber)

Returns the year of a date, an integer in the range 1900 - 9999.

``year(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

serialNumber
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a number in the date-time code used by Microsoft Excel.

#### Returns

FunctionResult<number>

### yearFrac(startDate, endDate, basis)

Returns the year fraction representing the number of whole days between start_date and end_date.

``yearFrac(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

startDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a serial date number that represents the start date.

endDate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is a serial date number that represents the end date.

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### yield(settlement, maturity, rate, pr, redemption, frequency, basis)

Returns the yield on a security that pays periodic interest.

``yield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, maturity: 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>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's maturity date, expressed as a serial date number.

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's annual coupon rate.

pr
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's price per \$100 face value.

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's redemption value per \$100 face value.

frequency
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the number of coupon payments per year.

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### yieldDisc(settlement, maturity, pr, redemption, basis)

Returns the annual yield for a discounted security. For example, a treasury bill.

``yieldDisc(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>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's maturity date, expressed as a serial date number.

pr
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's price per \$100 face value.

redemption
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's redemption value per \$100 face value.

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### yieldMat(settlement, maturity, issue, rate, pr, basis)

Returns the annual yield of a security that pays interest at maturity.

``yieldMat(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>, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

settlement
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's settlement date, expressed as a serial date number.

maturity
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's maturity date, expressed as a serial date number.

issue
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's issue date, expressed as a serial date number.

rate
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's interest rate at date of issue.

pr
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the security's price per \$100 face value.

basis
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the type of day count basis to use.

#### Returns

FunctionResult<number>

### z_Test(array, x, sigma)

Returns the one-tailed P-value of a z-test.

``z_Test(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>, sigma?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>): FunctionResult<number>;``

#### Parameters

array
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the array or range of data against which to test X.

x
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the value to test.

sigma
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult<any>

Is the population (known) standard deviation. If omitted, the sample standard deviation is used.

#### Returns

FunctionResult<number>