Excel.Functions class
An object for evaluating Excel functions.
- Extends
Remarks
Used by
Examples
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/50-workbook/workbook-built-in-functions.yaml
await Excel.run(async (context) => {
// This function uses VLOOKUP to find data in the "Wrench" row on the worksheet.
let range = context.workbook.worksheets.getItem("Sample").getRange("A1:D4");
// Get the value in the second column in the "Wrench" row.
let unitSoldInNov = context.workbook.functions.vlookup("Wrench", range, 2, false);
unitSoldInNov.load("value");
await context.sync();
console.log(" Number of wrenches sold in November = " + unitSoldInNov.value);
});
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. |
| accr |
Returns the accrued interest for a security that pays periodic interest. |
| accr |
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. |
| amor |
Returns the prorated linear depreciation of an asset for each accounting period. |
| amor |
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(x |
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. |
| ave |
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. |
| average |
Finds average(arithmetic mean) for the cells specified by a given condition or criteria. |
| average |
Finds average(arithmetic mean) for the cells specified by a given set of conditions or criteria. |
| baht |
Converts a number to text (baht). |
| base(number, radix, min |
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, shift |
Returns a number shifted left by shift_amount bits. |
| bitor(number1, number2) | Returns a bitwise 'Or' of two numbers. |
| bitrshift(number, shift |
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. |
| chi |
Returns the right-tailed probability of the chi-squared distribution. |
| chi |
Returns the left-tailed probability of the chi-squared distribution. |
| chi |
Returns the inverse of the right-tailed probability of the chi-squared distribution. |
| chi |
Returns the inverse of the left-tailed probability of the chi-squared distribution. |
| choose(index |
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, number |
Returns the number of combinations for a given number of items. |
| combina(number, number |
Returns the number of combinations with repetitions for a given number of items. |
| complex(real |
Converts real and imaginary coefficients into a complex number. |
| concatenate(values) | Joins several text strings into one text string. |
| confidence_Norm(alpha, standard |
Returns the confidence interval for a population mean, using a normal distribution. |
| confidence_T(alpha, standard |
Returns the confidence interval for a population mean, using a Student's T distribution. |
| convert(number, from |
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. |
| count |
Counts the number of empty cells in a specified range of cells. |
| count |
Counts the number of cells within a range that meet the given condition. |
| count |
Counts the number of cells specified by a given set of conditions or criteria. |
| coup |
Returns the number of days from the beginning of the coupon period to the settlement date. |
| coup |
Returns the number of days in the coupon period that contains the settlement date. |
| coup |
Returns the number of days from the settlement date to the next coupon date. |
| coup |
Returns the next coupon date after the settlement date. |
| coup |
Returns the number of coupons payable between the settlement date and maturity date. |
| coup |
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. |
| cum |
Returns the cumulative interest paid between two periods. |
| cum |
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(date |
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(serial |
Returns the day of the month, a number from 1 to 31. |
| days(end |
Returns the number of days between the two dates. |
| days360(start |
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. |
| dev |
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. |
| dollar |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. |
| dollar |
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. |
| dst |
Estimates the standard deviation based on a sample from selected database entries. |
| dst |
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(start |
Returns the serial number of the date that is the indicated number of months before or after the start date. |
| effect(nominal |
Returns the effective annual interest rate. |
| eo |
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(lower |
Returns the error function. |
| erfC_Precise(X) | Returns the complementary error function. |
| erfC(x) | Returns the complementary error function. |
| error_Type(error |
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, deg |
Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. |
| f_Dist(x, deg |
Returns the (left-tailed) F probability distribution (degree of diversity) for two data sets. |
| f_Inv_RT(probability, deg |
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, deg |
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. |
| fact |
Returns the double factorial of a number. |
| false() | Returns the logical value FALSE. |
| find(find |
Returns the starting position of one text string within another text string. FIND is case-sensitive. |
| findB(find |
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. |
| fisher |
Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x. |
| fixed(number, decimals, no |
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. |
| gamma |
Returns the natural logarithm of the gamma function. |
| gamma |
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. |
| geo |
Returns the geometric mean of an array or range of positive numeric data. |
| ge |
Tests whether a number is greater than a threshold value. |
| har |
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(lookup |
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(serial |
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.). |
| hyperlink(link |
Creates a shortcut or jump that opens a document stored on your hard drive, a network server, or on the Internet. |
| hyp |
Returns the hypergeometric distribution. |
| if(logical |
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. |
| im |
Returns the absolute value (modulus) of a complex number. |
| imaginary(inumber) | Returns the imaginary coefficient of a complex number. |
| im |
Returns the argument q, an angle expressed in radians. |
| im |
Returns the complex conjugate of a complex number. |
| im |
Returns the cosine of a complex number. |
| im |
Returns the hyperbolic cosine of a complex number. |
| im |
Returns the cotangent of a complex number. |
| im |
Returns the cosecant of a complex number. |
| im |
Returns the hyperbolic cosecant of a complex number. |
| im |
Returns the quotient of two complex numbers. |
| im |
Returns the exponential of a complex number. |
| im |
Returns the natural logarithm of a complex number. |
| im |
Returns the base-10 logarithm of a complex number. |
| im |
Returns the base-2 logarithm of a complex number. |
| im |
Returns a complex number raised to an integer power. |
| im |
Returns the product of 1 to 255 complex numbers. |
| im |
Returns the real coefficient of a complex number. |
| im |
Returns the secant of a complex number. |
| im |
Returns the hyperbolic secant of a complex number. |
| im |
Returns the sine of a complex number. |
| im |
Returns the hyperbolic sine of a complex number. |
| im |
Returns the square root of a complex number. |
| im |
Returns the difference of two complex numbers. |
| im |
Returns the sum of complex numbers. |
| im |
Returns the tangent of a complex number. |
| int(number) | Rounds a number down to the nearest integer. |
| int |
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. |
| is |
Checks whether a value is an error other than #N/A, and returns TRUE or FALSE. |
| is |
Checks whether a value is an error, and returns TRUE or FALSE. |
| is |
Returns TRUE if the number is even. |
| is |
Checks whether a reference is to a cell containing a formula, and returns TRUE or FALSE. |
| is |
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. |
| is |
Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE. |
| is |
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. |
| is |
Returns TRUE if the number is odd. |
| iso |
Returns the ISO week number in the year for a given date. |
| ispmt(rate, per, nper, pv) | Returns the interest paid during a specific period of an investment. |
| isref(value) | Checks whether a value is a reference, and returns TRUE or FALSE. |
| is |
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, num |
Returns the specified number of characters from the start of a text string. |
| leftb(text, num |
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. |
| log |
Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. |
| log |
Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. |
| lookup(lookup |
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(lookup |
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, start |
Returns the characters from the middle of a text string, given a starting position and length. |
| midb(text, start |
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(serial |
Returns the minute, a number from 0 to 59. |
| mirr(values, finance |
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(serial |
Returns the month, a number from 1 (January) to 12 (December). |
| mround(number, multiple) | Returns a number rounded to the desired multiple. |
| multi |
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). |
| neg |
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. |
| network |
Returns the number of whole workdays between two dates with custom weekend parameters. |
| network |
Returns the number of whole workdays between two dates. |
| nominal(effect |
Returns the annual nominal interest rate. |
| norm_Dist(x, mean, standard |
Returns the normal distribution for the specified mean and standard deviation. |
| norm_Inv(probability, mean, standard |
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). |
| number |
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. |
| odd |
Returns the price per $100 face value of a security with an odd first period. |
| odd |
Returns the yield of a security with an odd first period. |
| odd |
Returns the price per $100 face value of a security with an odd last period. |
| odd |
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. |
| percent |
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. |
| percent |
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. |
| permut(number, number |
Returns the number of permutations for a given number of objects that can be selected from the total objects. |
| permutationa(number, number |
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. |
| price |
Returns the price per $100 face value of a discounted security. |
| price |
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). |
| rand |
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(old |
Replaces part of a text string with a different text string. |
| replaceB(old |
Replaces part of a text string with a different text string. Use with double-byte character sets (DBCS). |
| rept(text, number |
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. |
| right(text, num |
Returns the specified number of characters from the end of a text string. |
| rightb(text, num |
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, num |
Rounds a number to a specified number of digits. |
| round |
Rounds a number down, toward zero. |
| round |
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(serial |
Returns the second, a number from 0 to 59. |
| series |
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. |
| sqrt |
Returns the square root of (number * Pi). |
| standardize(x, mean, standard |
Returns a normalized value from a distribution characterized by a mean and standard deviation. |
| st |
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text). |
| st |
Estimates standard deviation based on a sample (ignores logical values and text in the sample). |
| st |
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. |
| st |
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, old |
Replaces existing text with new text in a text string. |
| subtotal(function |
Returns a subtotal in a list or database. |
| sum(values) | Adds all the numbers in a range of cells. |
| sum |
Adds the cells specified by a given condition or criteria. |
| sum |
Adds the cells specified by a given set of conditions or criteria. |
| sum |
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, deg |
Returns the two-tailed Student's t-distribution. |
| t_Dist_RT(x, deg |
Returns the right-tailed Student's t-distribution. |
| t_Dist(x, deg |
Returns the left-tailed Student's t-distribution. |
| t_Inv_2T(probability, deg |
Returns the two-tailed inverse of the Student's t-distribution. |
| t_Inv(probability, deg |
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. |
| tbill |
Returns the bond-equivalent yield for a treasury bill. |
| tbill |
Returns the price per $100 face value for a treasury bill. |
| tbill |
Returns the yield for a treasury bill. |
| text(value, format |
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(time |
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 |
| trim(text) | Removes all spaces from a text string except for single spaces between words. |
| trim |
Returns the mean of the interior portion of a set of data values. |
| true() | Returns the logical value TRUE. |
| trunc(number, num |
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; compound data = 128. |
| 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, start |
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(lookup |
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(serial |
Returns a number from 1 to 7 identifying the day of the week of a date. |
| week |
Returns the week number in the year. |
| weibull_Dist(x, alpha, beta, cumulative) | Returns the Weibull distribution. |
| work |
Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. |
| work |
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(serial |
Returns the year of a date, an integer in the range 1900 - 9999. |
| year |
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. |
| yield |
Returns the annual yield for a discounted security. For example, a treasury bill. |
| yield |
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;Property Value
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the real number for which you want the absolute value.
Returns
Remarks
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, firstInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, par: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, calcMethod?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- issue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's issue date, expressed as a serial date number.
- firstInterest
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's first interest date, expressed as a serial date number.
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual coupon rate.
- par
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's par value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
- calcMethod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: to accrued interest from issue date = TRUE or omitted; to calculate from last coupon payment date = FALSE.
Returns
Remarks
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, settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, par: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- issue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's issue date, expressed as a serial date number.
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual coupon rate.
- par
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's par value.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the cosine of the angle you want and must be from -1 to 1.
Returns
Remarks
acosh(number)
Returns the inverse hyperbolic cosine of a number.
acosh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number equal to or greater than 1.
Returns
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the cotangent of the angle you want.
Returns
Remarks
acoth(number)
Returns the inverse hyperbolic cotangent of a number.
acoth(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the hyperbolic cotangent of the angle that you want.
Returns
Remarks
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, datePurchased: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the cost of the asset.
- datePurchased
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the date the asset is purchased.
- firstPeriod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the date of the end of the first period.
- salvage
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of life of the asset.
- period
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the period.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the rate of depreciation.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days.
Returns
Remarks
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, datePurchased: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the cost of the asset.
- datePurchased
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the date the asset is purchased.
- firstPeriod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the date of the end of the first period.
- salvage
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of life of the asset.
- period
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the period.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the rate of depreciation.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Year_basis : 0 for year of 360 days, 1 for actual, 3 for year of 365 days.
Returns
Remarks
and(values)
Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.
and(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
arabic(text)
Converts a Roman numeral to Arabic.
arabic(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Roman numeral you want to convert.
Returns
Remarks
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): FunctionResult; Parameters
- reference
Is a reference to a cell or range of cells and can refer to multiple areas.
Returns
Remarks
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): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a text, or a reference to a cell containing a text.
Returns
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the sine of the angle you want and must be from -1 to 1.
Returns
Remarks
asinh(number)
Returns the inverse hyperbolic sine of a number.
asinh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number equal to or greater than 1.
Returns
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the tangent of the angle you want.
Returns
Remarks
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, yNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- xNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the x-coordinate of the point.
- yNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the y-coordinate of the point.
Returns
Remarks
atanh(number)
Returns the inverse hyperbolic tangent of a number.
atanh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number between -1 and 1 excluding -1 and 1.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 arguments for which you want the average of the absolute deviations.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numeric arguments for which you want the average.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 arguments for which you want the average.
Returns
Remarks
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, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, averageRange?: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
Is the range of cells you want evaluated.
- criteria
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Are the actual cells to be used to find the average. If omitted, the cells in range are used.
Returns
Remarks
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, ...values: Array | number | string | boolean>): FunctionResult; Parameters
- averageRange
Are the actual cells to be used to find the average.
- values
-
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult
| 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
Remarks
bahtText(number)
Converts a number to text (baht).
bahtText(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number that you want to convert.
Returns
Remarks
base(number, radix, minLength)
Converts a number into a text representation with the given radix (base).
base(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, radix: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, minLength?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number that you want to convert.
- radix
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the base Radix that you want to convert the number into.
- minLength
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the minimum length of the returned string. If omitted leading zeros are not added.
Returns
Remarks
besselI(x, n)
Returns the modified Bessel function In(x).
besselI(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function.
- n
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the order of the Bessel function.
Returns
Remarks
besselJ(x, n)
Returns the Bessel function Jn(x).
besselJ(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function.
- n
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the order of the Bessel function.
Returns
Remarks
besselK(x, n)
Returns the modified Bessel function Kn(x).
besselK(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function.
- n
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the order of the function.
Returns
Remarks
besselY(x, n)
Returns the Bessel function Yn(x).
besselY(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function.
- n
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the order of the function.
Returns
Remarks
beta_Dist(x, alpha, beta, cumulative, A, B)
Returns the beta probability distribution function.
beta_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, A?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, B?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value between A and B at which to evaluate the function.
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution and must be greater than 0.
- beta
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution and must be greater than 0.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is an optional lower bound to the interval of x. If omitted, A = 0.
- B
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an optional upper bound to the interval of x. If omitted, B = 1.
Returns
Remarks
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, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, A?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, B?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability associated with the beta distribution.
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution and must be greater than 0.
- beta
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution and must be greater than 0.
- A
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an optional lower bound to the interval of x. If omitted, A = 0.
- B
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an optional upper bound to the interval of x. If omitted, B = 1.
Returns
Remarks
bin2Dec(number)
Converts a binary number to decimal.
bin2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the binary number you want to convert.
Returns
Remarks
bin2Hex(number, places)
Converts a binary number to hexadecimal.
bin2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the binary number you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
bin2Oct(number, places)
Converts a binary number to octal.
bin2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the binary number you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
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, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberS2?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- trials
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of independent trials.
- probabilityS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the probability of success on each trial.
- numberS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of successes in trials.
- numberS2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
If provided this function returns the probability that the number of successful trials shall lie between numberS and numberS2.
Returns
Remarks
binom_Dist(numberS, trials, probabilityS, cumulative)
Returns the individual term binomial distribution probability.
binom_Dist(numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, trials: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- numberS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of successes in trials.
- trials
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of independent trials.
- probabilityS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the probability of success on each trial.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.
Returns
Remarks
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, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- trials
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of Bernoulli trials.
- probabilityS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the probability of success on each trial, a number between 0 and 1 inclusive.
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the criterion value, a number between 0 and 1 inclusive.
Returns
Remarks
bitand(number1, number2)
Returns a bitwise 'And' of two numbers.
bitand(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
- number2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
Returns
Remarks
bitlshift(number, shiftAmount)
Returns a number shifted left by shift_amount bits.
bitlshift(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, shiftAmount: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
- shiftAmount
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of bits that you want to shift Number left by.
Returns
Remarks
bitor(number1, number2)
Returns a bitwise 'Or' of two numbers.
bitor(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
- number2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
Returns
Remarks
bitrshift(number, shiftAmount)
Returns a number shifted right by shift_amount bits.
bitrshift(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, shiftAmount: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
- shiftAmount
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of bits that you want to shift Number right by.
Returns
Remarks
bitxor(number1, number2)
Returns a bitwise 'Exclusive Or' of two numbers.
bitxor(number1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
- number2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal representation of the binary number you want to evaluate.
Returns
Remarks
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, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mode?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want to round.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the multiple to which you want to round.
- mode
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
When given and nonzero this function will round away from zero.
Returns
Remarks
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, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want to round.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the multiple to which you want to round.
Returns
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number between 1 and 255 specifying which character you want.
Returns
Remarks
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, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which you want to evaluate the distribution, a nonnegative number.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.
Returns
Remarks
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, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which you want to evaluate the distribution, a nonnegative number.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.
Returns
Remarks
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, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.
Returns
Remarks
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, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability associated with the chi-squared distribution, a value between 0 and 1 inclusive.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of degrees of freedom, a number between 1 and 10^10, excluding 10^10.
Returns
Remarks
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, ...values: Array>): FunctionResult; Parameters
- indexNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
>
List of parameters, whose elements are 1 to 254 numbers, cell references, defined names, formulas, functions, or text arguments from which CHOOSE selects.
Returns
Remarks
clean(text)
Removes all nonprintable characters from text.
clean(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any worksheet information from which you want to remove nonprintable characters.
Returns
Remarks
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): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text for which you want the code of the first character.
Returns
Remarks
columns(array)
Returns the number of columns in an array or reference.
columns(array: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
Is an array or array formula, or a reference to a range of cells for which you want the number of columns.
Returns
Remarks
combin(number, numberChosen)
Returns the number of combinations for a given number of items.
combin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of items.
- numberChosen
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of items in each combination.
Returns
Remarks
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, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of items.
- numberChosen
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of items in each combination.
Returns
Remarks
complex(realNum, iNum, suffix)
Converts real and imaginary coefficients into a complex number.
complex(realNum: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, iNum: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, suffix?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- realNum
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the real coefficient of the complex number.
- iNum
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the imaginary coefficient of the complex number.
- suffix
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the suffix for the imaginary component of the complex number.
Returns
Remarks
concatenate(values)
Joins several text strings into one text string.
concatenate(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
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, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, size: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is the sample size.
Returns
Remarks
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, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, size: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is the sample size.
Returns
Remarks
convert(number, fromUnit, toUnit)
Converts a number from one measurement system to another.
convert(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fromUnit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, toUnit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value in from_units to convert.
- fromUnit
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the units for number.
- toUnit
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the units for the result.
Returns
Remarks
cos(number)
Returns the cosine of an angle.
cos(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the cosine.
Returns
Remarks
cosh(number)
Returns the hyperbolic cosine of a number.
cosh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number.
Returns
Remarks
cot(number)
Returns the cotangent of an angle.
cot(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the cotangent.
Returns
Remarks
coth(number)
Returns the hyperbolic cotangent of a number.
coth(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the hyperbolic cotangent.
Returns
Remarks
count(values)
Counts the number of cells in a range that contain numbers.
count(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
countA(values)
Counts the number of cells in a range that are not empty.
countA(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
countBlank(range)
Counts the number of empty cells in a specified range of cells.
countBlank(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
Is the range from which you want to count the empty cells.
Returns
Remarks
countIf(range, criteria)
Counts the number of cells within a range that meet the given condition.
countIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
Is the range of cells from which you want to count nonblank cells.
- criteria
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the condition in the form of a number, expression, or text that defines which cells will be counted.
Returns
Remarks
countIfs(values)
Counts the number of cells specified by a given set of conditions or criteria.
countIfs(...values: Array | number | string | boolean>): FunctionResult; Parameters
- values
-
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult
| 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
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
csc(number)
Returns the cosecant of an angle.
csc(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the cosecant.
Returns
Remarks
csch(number)
Returns the hyperbolic cosecant of an angle.
csch(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the hyperbolic cosecant.
Returns
Remarks
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, nper: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the interest rate.
- nper
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of payment periods.
- pv
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value.
- startPeriod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the first period in the calculation.
- endPeriod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the last period in the calculation.
- type
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the timing of the payment.
Returns
Remarks
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, nper: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endPeriod: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the interest rate.
- nper
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of payment periods.
- pv
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value.
- startPeriod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the first period in the calculation.
- endPeriod
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the last period in the calculation.
- type
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the timing of the payment.
Returns
Remarks
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, month: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, day: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- year
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number from 1900 or 1904 (depending on the workbook's date system) to 9999.
- month
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number from 1 to 12 representing the month of the year.
- day
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number from 1 to 31 representing the day of the month.
Returns
Remarks
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 | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- dateText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
day(serialNumber)
Returns the day of the month, a number from 1 to 31.
day(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number in the date-time code used by Microsoft Excel.
Returns
Remarks
days(endDate, startDate)
Returns the number of days between the two dates.
days(endDate: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startDate: string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- endDate
-
string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
startDate and endDate are the two dates between which you want to know the number of days.
Returns
Remarks
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, endDate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, method?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is a logical value specifying the calculation method: U.S. (NASD) = FALSE or omitted; European = TRUE.
Returns
Remarks
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, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, month?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the initial cost of the asset.
- salvage
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of the life of the asset.
- life
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is the number of months in the first year. If month is omitted, it is assumed to be 12.
Returns
Remarks
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): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a text, or a reference to a cell containing a text.
Returns
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, period: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, factor?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the initial cost of the asset.
- salvage
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of the life of the asset.
- life
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is the rate at which the balance declines. If Factor is omitted, it is assumed to be 2 (the double-declining balance method).
Returns
Remarks
dec2Bin(number, places)
Converts a decimal number to binary.
dec2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal integer you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
dec2Hex(number, places)
Converts a decimal number to hexadecimal.
dec2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal integer you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
dec2Oct(number, places)
Converts a decimal number to octal.
dec2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the decimal integer you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
decimal(number, radix)
Converts a text representation of a number in a given base into a decimal number.
decimal(number: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, radix: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number that you want to convert.
- radix
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the base Radix of the number you are converting.
Returns
Remarks
degrees(angle)
Converts radians to degrees.
degrees(angle: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- angle
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians that you want to convert.
Returns
Remarks
delta(number1, number2)
Tests whether two numbers are equal.
delta(number1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number2?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number1
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the first number.
- number2
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the second number.
Returns
Remarks
devSq(values)
Returns the sum of squares of deviations of data points from their sample mean.
devSq(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 arguments, or an array or array reference, on which you want DEVSQ to calculate.
Returns
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
disc(settlement, maturity, pr, redemption, basis)
Returns the discount rate for a security.
disc(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's price per $100 face value.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
dollar(number, decimals)
Converts a number to text, using currency format.
dollar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the number of digits to the right of the decimal point. The number is rounded as necessary; if omitted, Decimals = 2.
Returns
Remarks
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, fraction: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- fractionalDollar
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number expressed as a fraction.
- fraction
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the integer to use in the denominator of the fraction.
Returns
Remarks
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, fraction: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- decimalDollar
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a decimal number.
- fraction
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the integer to use in the denominator of a fraction.
Returns
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
dstDev(database, field, criteria)
Estimates the standard deviation based on a sample from selected database entries.
dstDev(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, coupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- coupon
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual coupon rate.
- yld
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual yield.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
dvar(database, field, criteria)
Estimates variance based on a sample from selected database entries.
dvar(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
dvarP(database, field, criteria)
Calculates variance based on the entire population of selected database entries.
dvarP(database: Excel.Range | Excel.RangeReference | Excel.FunctionResult, field: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- database
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
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
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
Remarks
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, significance: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want to round.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the multiple to which you want to round.
Returns
Remarks
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, months: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- months
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of months before or after startDate.
Returns
Remarks
effect(nominalRate, npery)
Returns the effective annual interest rate.
effect(nominalRate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, npery: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- nominalRate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the nominal interest rate.
- npery
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of compounding periods per year.
Returns
Remarks
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, months: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- months
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of months before or after the startDate.
Returns
Remarks
erf_Precise(X)
Returns the error function.
erf_Precise(X: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- X
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the lower bound for integrating ERF.PRECISE.
Returns
Remarks
erf(lowerLimit, upperLimit)
Returns the error function.
erf(lowerLimit: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, upperLimit?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- lowerLimit
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the lower bound for integrating ERF.
- upperLimit
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the upper bound for integrating ERF.
Returns
Remarks
erfC_Precise(X)
Returns the complementary error function.
erfC_Precise(X: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- X
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the lower bound for integrating ERFC.PRECISE.
Returns
Remarks
erfC(x)
Returns the complementary error function.
erfC(x: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the lower bound for integrating ERF.
Returns
Remarks
error_Type(errorVal)
Returns a number matching an error value.
error_Type(errorVal: string | number | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- errorVal
-
string | number | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to round.
Returns
Remarks
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, text2: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text1
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the first text string.
- text2
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the second text string.
Returns
Remarks
exp(number)
Returns e raised to the power of a given number.
exp(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the exponent applied to the base e. The constant e equals 2.71828182845904, the base of the natural logarithm.
Returns
Remarks
expon_Dist(x, lambda, cumulative)
Returns the exponential distribution.
expon_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lambda: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value of the function, a nonnegative number.
- lambda
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the parameter value, a positive number.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.
Returns
Remarks
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, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function, a nonnegative number.
- degFreedom1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- degFreedom2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
Returns
Remarks
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, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function, a nonnegative number.
- degFreedom1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- degFreedom2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.
Returns
Remarks
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, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive.
- degFreedom1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- degFreedom2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
Returns
Remarks
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, degFreedom1: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom2: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability associated with the F cumulative distribution, a number between 0 and 1 inclusive.
- degFreedom1
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numerator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
- degFreedom2
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the denominator degrees of freedom, a number between 1 and 10^10, excluding 10^10.
Returns
Remarks
fact(number)
Returns the factorial of a number, equal to 123*...* Number.
fact(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the nonnegative number you want the factorial of.
Returns
Remarks
factDouble(number)
Returns the double factorial of a number.
factDouble(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which to return the double factorial.
Returns
Remarks
false()
Returns the logical value FALSE.
false(): FunctionResult; Returns
Remarks
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, withinText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- findText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the text containing the text you want to find.
- startNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies the character at which to start the search. The first character in withinText is character number 1. If omitted, startNum = 1.
Returns
Remarks
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, withinText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startNum?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- findText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text you want to find.
- withinText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text containing the text you want to find.
- startNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies the character at which to start the search.
Returns
Remarks
fisher(x)
Returns the Fisher transformation.
fisher(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want the transformation, a number between -1 and 1, excluding -1 and 1.
Returns
Remarks
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): FunctionResult; Parameters
- y
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want to perform the inverse of the transformation.
Returns
Remarks
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, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, noCommas?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number you want to round and convert to text.
- decimals
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of digits to the right of the decimal point. If omitted, Decimals = 2.
- noCommas
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: do not display commas in the returned text = TRUE; do display commas in the returned text = FALSE or omitted.
Returns
Remarks
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, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mode?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want to round.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the multiple to which you want to round.
- mode
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
When given and nonzero this function will round towards zero.
Returns
Remarks
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, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numeric value you want to round.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the multiple to which you want to round.
Returns
Remarks
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, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the total number of payment periods in the investment.
- pmt
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the payment made each period; it cannot change over the life of the investment.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Remarks
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, schedule: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- principal
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value.
- schedule
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
Is an array of interest rates to apply.
Returns
Remarks
gamma_Dist(x, alpha, beta, cumulative)
Returns the gamma distribution.
gamma_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which you want to evaluate the distribution, a nonnegative number.
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution, a positive number.
- beta
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a logical value: return the cumulative distribution function = TRUE; return the probability mass function = FALSE or omitted.
Returns
Remarks
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, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the probability associated with the gamma distribution, a number between 0 and 1, inclusive.
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution, a positive number.
- beta
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution, a positive number. If beta = 1, GAMMA.INV returns the inverse of the standard gamma distribution.
Returns
Remarks
gamma(x)
Returns the Gamma function value.
gamma(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want to calculate Gamma.
Returns
Remarks
gammaLn_Precise(x)
Returns the natural logarithm of the gamma function.
gammaLn_Precise(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want to calculate GAMMALN.PRECISE, a positive number.
Returns
Remarks
gammaLn(x)
Returns the natural logarithm of the gamma function.
gammaLn(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want to calculate GAMMALN, a positive number.
Returns
Remarks
gauss(x)
Returns 0.5 less than the standard normal cumulative distribution.
gauss(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want the distribution.
Returns
Remarks
gcd(values)
Returns the greatest common divisor.
gcd(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 values.
Returns
Remarks
geoMean(values)
Returns the geometric mean of an array or range of positive numeric data.
geoMean(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
geStep(number, step)
Tests whether a number is greater than a threshold value.
geStep(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, step?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to test against step.
- step
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the threshold value.
Returns
Remarks
harMean(values)
Returns the harmonic mean of a data set of positive numbers: the reciprocal of the arithmetic mean of reciprocals.
harMean(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
hex2Bin(number, places)
Converts a Hexadecimal number to binary.
hex2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the hexadecimal number you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
hex2Dec(number)
Converts a hexadecimal number to decimal.
hex2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the hexadecimal number you want to convert.
Returns
Remarks
hex2Oct(number, places)
Converts a hexadecimal number to octal.
hex2Oct(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the hexadecimal number you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
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, tableArray: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, rowIndexNum: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, rangeLookup?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- lookupValue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
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
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
Remarks
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): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
hyperlink(linkLocation, friendlyName)
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, friendlyName?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- linkLocation
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is text or a number that is displayed in the cell. If omitted, the cell displays the linkLocation text.
Returns
Remarks
hypGeom_Dist(sampleS, numberSample, populationS, numberPop, cumulative)
Returns the hypergeometric distribution.
hypGeom_Dist(sampleS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberSample: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, populationS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numberPop: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- sampleS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of successes in the sample.
- numberSample
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the size of the sample.
- populationS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of successes in the population.
- numberPop
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the population size.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.
Returns
Remarks
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, valueIfTrue?: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult, valueIfFalse?: Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- logicalTest
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any value or expression that can be evaluated to TRUE or FALSE.
- valueIfTrue
-
Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult
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
Is the value that is returned if logicalTest is FALSE. If omitted, FALSE is returned.
Returns
Remarks
imAbs(inumber)
Returns the absolute value (modulus) of a complex number.
imAbs(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the absolute value.
Returns
Remarks
imaginary(inumber)
Returns the imaginary coefficient of a complex number.
imaginary(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the imaginary coefficient.
Returns
Remarks
imArgument(inumber)
Returns the argument q, an angle expressed in radians.
imArgument(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the argument.
Returns
Remarks
imConjugate(inumber)
Returns the complex conjugate of a complex number.
imConjugate(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the conjugate.
Returns
Remarks
imCos(inumber)
Returns the cosine of a complex number.
imCos(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the cosine.
Returns
Remarks
imCosh(inumber)
Returns the hyperbolic cosine of a complex number.
imCosh(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the hyperbolic cosine.
Returns
Remarks
imCot(inumber)
Returns the cotangent of a complex number.
imCot(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the cotangent.
Returns
Remarks
imCsc(inumber)
Returns the cosecant of a complex number.
imCsc(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the cosecant.
Returns
Remarks
imCsch(inumber)
Returns the hyperbolic cosecant of a complex number.
imCsch(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the hyperbolic cosecant.
Returns
Remarks
imDiv(inumber1, inumber2)
Returns the quotient of two complex numbers.
imDiv(inumber1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, inumber2: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber1
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the complex numerator or dividend.
- inumber2
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the complex denominator or divisor.
Returns
Remarks
imExp(inumber)
Returns the exponential of a complex number.
imExp(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the exponential.
Returns
Remarks
imLn(inumber)
Returns the natural logarithm of a complex number.
imLn(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the natural logarithm.
Returns
Remarks
imLog10(inumber)
Returns the base-10 logarithm of a complex number.
imLog10(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the common logarithm.
Returns
Remarks
imLog2(inumber)
Returns the base-2 logarithm of a complex number.
imLog2(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the base-2 logarithm.
Returns
Remarks
imPower(inumber, number)
Returns a complex number raised to an integer power.
imPower(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number you want to raise to a power.
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the power to which you want to raise the complex number.
Returns
Remarks
imProduct(values)
Returns the product of 1 to 255 complex numbers.
imProduct(...values: Array>): FunctionResult; Parameters
- values
-
Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult
>
Inumber1, Inumber2,... are from 1 to 255 complex numbers to multiply.
Returns
Remarks
imReal(inumber)
Returns the real coefficient of a complex number.
imReal(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the real coefficient.
Returns
Remarks
imSec(inumber)
Returns the secant of a complex number.
imSec(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the secant.
Returns
Remarks
imSech(inumber)
Returns the hyperbolic secant of a complex number.
imSech(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the hyperbolic secant.
Returns
Remarks
imSin(inumber)
Returns the sine of a complex number.
imSin(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the sine.
Returns
Remarks
imSinh(inumber)
Returns the hyperbolic sine of a complex number.
imSinh(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the hyperbolic sine.
Returns
Remarks
imSqrt(inumber)
Returns the square root of a complex number.
imSqrt(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the square root.
Returns
Remarks
imSub(inumber1, inumber2)
Returns the difference of two complex numbers.
imSub(inumber1: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, inumber2: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber1
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the complex number from which to subtract inumber2.
- inumber2
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the complex number to subtract from inumber1.
Returns
Remarks
imSum(values)
Returns the sum of complex numbers.
imSum(...values: Array>): FunctionResult; Parameters
- values
-
Array<Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult
>
List of parameters, whose elements are from 1 to 255 complex numbers to add.
Returns
Remarks
imTan(inumber)
Returns the tangent of a complex number.
imTan(inumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- inumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a complex number for which you want the tangent.
Returns
Remarks
int(number)
Rounds a number down to the nearest integer.
int(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the real number you want to round down to an integer.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, investment: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- investment
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the amount invested in the security.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the amount to be received at maturity.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is the total number of payment periods in an investment.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
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
Remarks
irr(values, guess)
Returns the internal rate of return for a series of cash flows.
irr(values: Excel.Range | Excel.RangeReference | Excel.FunctionResult, guess?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- values
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
Is a number that you guess is close to the result of IRR; 0.1 (10 percent) if omitted.
Returns
Remarks
isErr(value)
Checks whether a value is an error other than #N/A, and returns TRUE or FALSE.
isErr(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
isError(value)
Checks whether a value is an error, and returns TRUE or FALSE.
isError(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
isEven(number)
Returns TRUE if the number is even.
isEven(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to test.
Returns
Remarks
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): FunctionResult; Parameters
- reference
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
Remarks
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): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want tested: a cell; a formula; or a name referring to a cell, formula, or value.
Returns
Remarks
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): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want to round.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the optional multiple to which you want to round.
Returns
Remarks
isOdd(number)
Returns TRUE if the number is odd.
isOdd(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to test.
Returns
Remarks
isoWeekNum(date)
Returns the ISO week number in the year for a given date.
isoWeekNum(date: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- date
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the date-time code used by Microsoft Excel for date and time calculation.
Returns
Remarks
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, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.
- per
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Period for which you want to find the interest.
- nper
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Number of payment periods in an investment.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Lump sum amount that a series of future payments is right now.
Returns
Remarks
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): FunctionResult; Parameters
- value
-
Excel.Range | number | string | boolean | Excel.RangeReference | Excel.FunctionResult
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
Remarks
isText(value)
Checks whether a value is text, and returns TRUE or FALSE.
isText(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
kurt(values)
Returns the kurtosis of a data set.
kurt(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
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, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the position (from the largest) in the array or cell range of the value to return.
Returns
Remarks
lcm(values)
Returns the least common multiple.
lcm(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 values for which you want the least common multiple.
Returns
Remarks
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, numChars?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text string containing the characters you want to extract.
- numChars
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies how many characters you want LEFT to extract; 1 if omitted.
Returns
Remarks
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, numBytes?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text string containing the characters you want to extract.
- numBytes
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies how many characters you want LEFT to return.
Returns
Remarks
len(text)
Returns the number of characters in a text string.
len(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text whose length you want to find. Spaces count as characters.
Returns
Remarks
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): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text whose length you want to find.
Returns
Remarks
ln(number)
Returns the natural logarithm of a number.
ln(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the positive real number for which you want the natural logarithm.
Returns
Remarks
log(number, base)
Returns the logarithm of a number to the base you specify.
log(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, base?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the positive real number for which you want the logarithm.
- base
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the base of the logarithm; 10 if omitted.
Returns
Remarks
log10(number)
Returns the base-10 logarithm of a number.
log10(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the positive real number for which you want the base-10 logarithm.
Returns
Remarks
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, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function, a positive number.
- mean
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the mean of ln(x).
- standardDev
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the standard deviation of ln(x), a positive number.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.
Returns
Remarks
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, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability associated with the lognormal distribution, a number between 0 and 1, inclusive.
- mean
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the mean of ln(x).
- standardDev
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the standard deviation of ln(x), a positive number.
Returns
Remarks
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, lookupVector: Excel.Range | Excel.RangeReference | Excel.FunctionResult, resultVector?: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- lookupValue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a range that contains only one row or one column of text, numbers, or logical values, placed in ascending order.
- resultVector
Is a range that contains only one row or column, the same size as lookupVector.
Returns
Remarks
lower(text)
Converts all letters in a text string to lowercase.
lower(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text you want to convert to lowercase. Characters in Text that are not letters are not changed.
Returns
Remarks
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, lookupArray: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, matchType?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- lookupValue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is a number 1, 0, or -1 indicating which value to return.
Returns
Remarks
max(values)
Returns the largest value in a set of values. Ignores logical values and text.
max(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the maximum.
Returns
Remarks
maxA(values)
Returns the largest value in a set of values. Does not ignore logical values and text.
maxA(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the maximum.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, coupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- coupon
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual coupon rate.
- yld
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual yield.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
median(values)
Returns the median, or the number in the middle of the set of given numbers.
median(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
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, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numChars: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text string from which you want to extract the characters.
- startNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Specifies how many characters to return from Text.
Returns
Remarks
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, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numBytes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text string containing the characters you want to extract.
- startNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the position of the first character you want to extract in text.
- numBytes
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies how many characters to return from text.
Returns
Remarks
min(values)
Returns the smallest number in a set of values. Ignores logical values and text.
min(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the minimum.
Returns
Remarks
minA(values)
Returns the smallest value in a set of values. Does not ignore logical values and text.
minA(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numbers, empty cells, logical values, or text numbers for which you want the minimum.
Returns
Remarks
minute(serialNumber)
Returns the minute, a number from 0 to 59.
minute(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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, financeRate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, reinvestRate: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- values
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
Is the interest rate you pay on the money used in the cash flows.
- reinvestRate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the interest rate you receive on the cash flows as you reinvest them.
Returns
Remarks
mod(number, divisor)
Returns the remainder after a number is divided by a divisor.
mod(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, divisor: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number for which you want to find the remainder after the division is performed.
- divisor
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number by which you want to divide Number.
Returns
Remarks
month(serialNumber)
Returns the month, a number from 1 (January) to 12 (December).
month(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number in the date-time code used by Microsoft Excel.
Returns
Remarks
mround(number, multiple)
Returns a number rounded to the desired multiple.
mround(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, multiple: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to round.
- multiple
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the multiple to which you want to round number.
Returns
Remarks
multiNomial(values)
Returns the multinomial of a set of numbers.
multiNomial(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 values for which you want the multinomial.
Returns
Remarks
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): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want converted.
Returns
Remarks
na()
Returns the error value #N/A (value not available).
na(): FunctionResult; Returns
Remarks
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, numberS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, probabilityS: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- numberF
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of failures.
- numberS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the threshold number of successes.
- probabilityS
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the probability of a success; a number between 0 and 1.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.
Returns
Remarks
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, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, weekend?: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- endDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the end date.
- weekend
-
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number or string specifying when weekends occur.
- holidays
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
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
Remarks
networkDays(startDate, endDate, holidays)
Returns the number of whole workdays between two dates.
networkDays(startDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- endDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the end date.
- holidays
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
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
Remarks
nominal(effectRate, npery)
Returns the annual nominal interest rate.
nominal(effectRate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, npery: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- effectRate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the effective interest rate.
- npery
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of compounding periods per year.
Returns
Remarks
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, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want the distribution.
- mean
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the arithmetic mean of the distribution.
- standardDev
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the standard deviation of the distribution, a positive number.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.
Returns
Remarks
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, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive.
- mean
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the arithmetic mean of the distribution.
- standardDev
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the standard deviation of the distribution, a positive number.
Returns
Remarks
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, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- z
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want the distribution.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value for the function to return: the cumulative distribution function = TRUE; the probability density function = FALSE.
Returns
Remarks
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): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a probability corresponding to the normal distribution, a number between 0 and 1 inclusive.
Returns
Remarks
not(logical)
Changes FALSE to TRUE, or TRUE to FALSE.
not(logical: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- logical
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a value or expression that can be evaluated to TRUE or FALSE.
Returns
Remarks
now()
Returns the current date and time formatted as a date and time.
now(): FunctionResult; Returns
Remarks
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, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the payment made each period; it cannot change over the life of the investment.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.
Returns
Remarks
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, ...values: Array>): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the rate of discount over the length of one period.
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
numberValue(text, decimalSeparator, groupSeparator)
Converts text to number in a locale-independent manner.
numberValue(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimalSeparator?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, groupSeparator?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the string representing the number you want to convert.
- decimalSeparator
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the character used as the decimal separator in the string.
- groupSeparator
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the character used as the group separator in the string.
Returns
Remarks
oct2Bin(number, places)
Converts an octal number to binary.
oct2Bin(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the octal number you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
oct2Dec(number)
Converts an octal number to decimal.
oct2Dec(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the octal number you want to convert.
Returns
Remarks
oct2Hex(number, places)
Converts an octal number to hexadecimal.
oct2Hex(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, places?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the octal number you want to convert.
- places
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters to use.
Returns
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to round.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstCoupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- issue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's issue date, expressed as a serial date number.
- firstCoupon
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's first coupon date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's interest rate.
- yld
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual yield.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, firstCoupon: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- issue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's issue date, expressed as a serial date number.
- firstCoupon
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's first coupon date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's interest rate.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's price.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lastInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- lastInterest
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's last coupon date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's interest rate.
- yld
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual yield.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, lastInterest: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- lastInterest
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's last coupon date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's interest rate.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's price.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 conditions that you want to test that can be either TRUE or FALSE.
Returns
Remarks
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, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the interest rate per period.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value of the investment.
- fv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the desired future value of the investment.
Returns
Remarks
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, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or range of data that defines relative standing.
- k
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the percentile value that is between 0 through 1, inclusive.
Returns
Remarks
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, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or range of data that defines relative standing.
- k
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the percentile value that is between 0 through 1, inclusive.
Returns
Remarks
percentRank_Exc(array, x, significance)
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
percentRank_Exc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or range of data with numeric values that defines relative standing.
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want to know the rank.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%).
Returns
Remarks
percentRank_Inc(array, x, significance)
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.
percentRank_Inc(array: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, significance?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or range of data with numeric values that defines relative standing.
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value for which you want to know the rank.
- significance
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an optional value that identifies the number of significant digits for the returned percentage, three digits if omitted (0.xxx%).
Returns
Remarks
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, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of objects.
- numberChosen
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of objects in each permutation.
Returns
Remarks
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, numberChosen: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of objects.
- numberChosen
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of objects in each permutation.
Returns
Remarks
phi(x)
Returns the value of the density function for a standard normal distribution.
phi(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number for which you want the density of the standard normal distribution.
Returns
Remarks
pi()
Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
pi(): FunctionResult; Returns
Remarks
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, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the total number of payments for the loan.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value: the total amount that a series of future payments is worth now.
- fv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.
Returns
Remarks
poisson_Dist(x, mean, cumulative)
Returns the Poisson distribution.
poisson_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of events.
- mean
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the expected numeric value, a positive number.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative Poisson probability, use TRUE; for the Poisson probability mass function, use FALSE.
Returns
Remarks
power(number, power)
Returns the result of a number raised to a power.
power(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, power: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the base number, any real number.
- power
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the exponent, to which the base number is raised.
Returns
Remarks
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, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Specifies the period and must be in the range 1 to nper.
- nper
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of payment periods in an investment.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value: the total amount that a series of future payments is worth now.
- fv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual coupon rate.
- yld
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual yield.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- discount
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's discount rate.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, yld: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- issue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's issue date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's interest rate at date of issue.
- yld
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual yield.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
product(values)
Multiplies all the numbers given as arguments.
product(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numbers, logical values, or text representations of numbers that you want to multiply.
Returns
Remarks
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): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing text to partially capitalize.
Returns
Remarks
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, nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the total number of payment periods in an investment.
- pmt
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the payment made each period and cannot change over the life of the investment.
- fv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.
Returns
Remarks
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, quart: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or cell range of numeric values for which you want the quartile value.
- quart
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4.
Returns
Remarks
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, quart: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or cell range of numeric values for which you want the quartile value.
- quart
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4.
Returns
Remarks
quotient(numerator, denominator)
Returns the integer portion of a division.
quotient(numerator: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, denominator: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- numerator
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the dividend.
- denominator
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the divisor.
Returns
Remarks
radians(angle)
Converts degrees to radians.
radians(angle: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- angle
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an angle in degrees that you want to convert.
Returns
Remarks
rand()
Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).
rand(): FunctionResult; Returns
Remarks
randBetween(bottom, top)
Returns a random number between the numbers you specify.
randBetween(bottom: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, top: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- bottom
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the smallest integer RANDBETWEEN will return.
- top
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the largest integer RANDBETWEEN will return.
Returns
Remarks
Examples
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/30-events/events-worksheet.yaml
await Excel.run(async (context) => {
let sheet = context.workbook.worksheets.getItem("Sample");
let randomResult = context.workbook.functions.randBetween(1, 3000).load("value");
await context.sync();
const row: Excel.TableRow = sheet.tables.getItem("SalesTable").rows.getItemAt(0);
let newValue = [["Frames", 5000, 7000, 6544, randomResult.value, "=SUM(B2:E2)"]];
row.values = newValue;
row.load("values");
await context.sync();
});
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, ref: Excel.Range | Excel.RangeReference | Excel.FunctionResult, order?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number for which you want to find the rank.
Is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored.
- order
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value.
Returns
Remarks
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, ref: Excel.Range | Excel.RangeReference | Excel.FunctionResult, order?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number for which you want to find the rank.
Is an array of, or a reference to, a list of numbers. Nonnumeric values are ignored.
- order
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number: rank in the list sorted descending = 0 or omitted; rank in the list sorted ascending = any nonzero value.
Returns
Remarks
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, pmt: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, type?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, guess?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- nper
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the total number of payment periods for the loan or investment.
- pmt
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the present value: the total amount that a series of future payments is worth now.
- fv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is your guess for what the rate will be; if omitted, Guess = 0.1 (10 percent).
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, investment: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- investment
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the amount invested in the security.
- discount
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's discount rate.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numChars: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- oldText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is text in which you want to replace some characters.
- startNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the position of the character in oldText that you want to replace with newText.
- numChars
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters in oldText that you want to replace.
- newText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text that will replace characters in oldText.
Returns
Remarks
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, startNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numBytes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- oldText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is text in which you want to replace some characters.
- startNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the position of the character in oldText that you want to replace with newText.
- numBytes
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of characters in oldText that you want to replace with newText.
- newText
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text that will replace characters in oldText.
Returns
Remarks
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, numberTimes: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text you want to repeat.
- numberTimes
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a positive number specifying the number of times to repeat text.
Returns
Remarks
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, numChars?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text string that contains the characters you want to extract.
- numChars
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies how many characters you want to extract, 1 if omitted.
Returns
Remarks
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, numBytes?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text string containing the characters you want to extract.
- numBytes
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies how many characters you want to extract.
Returns
Remarks
roman(number, form)
Converts an Arabic numeral to Roman, as text.
roman(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, form?: boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Arabic numeral you want to convert.
- form
-
boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number specifying the type of Roman numeral you want.
Returns
Remarks
round(number, numDigits)
Rounds a number to a specified number of digits.
round(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number you want to round.
- numDigits
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
roundDown(number, numDigits)
Rounds a number down, toward zero.
roundDown(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number that you want rounded down.
- numDigits
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
roundUp(number, numDigits)
Rounds a number up, away from zero.
roundUp(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, numDigits: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number that you want rounded up.
- numDigits
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
rows(array)
Returns the number of rows in a reference or array.
rows(array: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
Is an array, an array formula, or a reference to a range of cells for which you want the number of rows.
Returns
Remarks
rri(nper, pv, fv)
Returns an equivalent interest rate for the growth of an investment.
rri(nper: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, fv: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- nper
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of periods for the investment.
- pv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the present value of the investment.
- fv
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the future value of the investment.
Returns
Remarks
sec(number)
Returns the secant of an angle.
sec(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the secant.
Returns
Remarks
sech(number)
Returns the hyperbolic secant of an angle.
sech(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the hyperbolic secant.
Returns
Remarks
second(serialNumber)
Returns the second, a number from 0 to 59.
second(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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, n: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, m: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, coefficients: Excel.Range | string | number | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the input value to the power series.
- n
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the initial power to which you want to raise x.
- m
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the step by which to increase n for each term in the series.
- coefficients
-
Excel.Range | string | number | boolean | Excel.RangeReference | Excel.FunctionResult
Is a set of coefficients by which each successive power of x is multiplied.
Returns
Remarks
sheet(value)
Returns the sheet number of the referenced sheet.
sheet(value?: Excel.Range | string | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- value
-
Excel.Range | string | Excel.RangeReference | Excel.FunctionResult
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
Remarks
sheets(reference)
Returns the number of sheets in a reference.
sheets(reference?: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- reference
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
Remarks
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): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number.
Returns
Remarks
sin(number)
Returns the sine of an angle.
sin(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the sine. Degrees * PI()/180 = radians.
Returns
Remarks
sinh(number)
Returns the hyperbolic sine of a number.
sinh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
skew(values)
Returns the skewness of a distribution: a characterization of the degree of asymmetry of a distribution around its mean.
skew(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
sln(cost, salvage, life)
Returns the straight-line depreciation of an asset for one period.
sln(cost: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the initial cost of the asset.
- salvage
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of the life of the asset.
- life
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).
Returns
Remarks
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, k: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the position (from the smallest) in the array or range of the value to return.
Returns
Remarks
sqrt(number)
Returns the square root of a number.
sqrt(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number for which you want the square root.
Returns
Remarks
sqrtPi(number)
Returns the square root of (number * Pi).
sqrtPi(number: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number by which p is multiplied.
Returns
Remarks
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, mean: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, standardDev: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value you want to normalize.
- mean
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the arithmetic mean of the distribution.
- standardDev
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the standard deviation of the distribution, a positive number.
Returns
Remarks
stDev_P(values)
Calculates standard deviation based on the entire population given as arguments (ignores logical values and text).
stDev_P(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numbers corresponding to a population and can be numbers or references that contain numbers.
Returns
Remarks
stDev_S(values)
Estimates standard deviation based on a sample (ignores logical values and text in the sample).
stDev_S(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
substitute(text, oldText, newText, instanceNum)
Replaces existing text with new text in a text string.
substitute(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, oldText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, newText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, instanceNum?: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
Is the text you want to replace oldText with.
- instanceNum
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Specifies which occurrence of oldText you want to replace. If omitted, every instance of oldText is replaced.
Returns
Remarks
subtotal(functionNum, values)
Returns a subtotal in a list or database.
subtotal(functionNum: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array>): FunctionResult; Parameters
- functionNum
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number 1 to 11 that specifies the summary function for the subtotal.
- values
-
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult
>
List of parameters, whose elements are 1 to 254 ranges or references for which you want the subtotal.
Returns
Remarks
sum(values)
Adds all the numbers in a range of cells.
sum(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
Examples
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/50-workbook/workbook-built-in-functions.yaml
await Excel.run(async (context) => {
// This function uses VLOOKUP to find data in the "Wrench" row
// on the worksheet, and then it uses SUM to combine the values.
let range = context.workbook.worksheets.getItem("Sample").getRange("A1:D4");
// Get the values in the second, third, and fourth columns in the "Wrench" row,
// and combine those values with SUM.
let sumOfTwoLookups = context.workbook.functions.sum(
context.workbook.functions.vlookup("Wrench", range, 2, false),
context.workbook.functions.vlookup("Wrench", range, 3, false),
context.workbook.functions.vlookup("Wrench", range, 4, false)
);
sumOfTwoLookups.load("value");
await context.sync();
console.log(" Number of wrenches sold in November, December, and January = " + sumOfTwoLookups.value);
});
sumIf(range, criteria, sumRange)
Adds the cells specified by a given condition or criteria.
sumIf(range: Excel.Range | Excel.RangeReference | Excel.FunctionResult, criteria: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, sumRange?: Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
Is the range of cells you want evaluated.
- criteria
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the condition or criteria in the form of a number, expression, or text that defines which cells will be added.
- sumRange
Are the actual cells to sum. If omitted, the cells in range are used.
Returns
Remarks
sumIfs(sumRange, values)
Adds the cells specified by a given set of conditions or criteria.
sumIfs(sumRange: Excel.Range | Excel.RangeReference | Excel.FunctionResult, ...values: Array | number | string | boolean>): FunctionResult; Parameters
- sumRange
Are the actual cells to sum.
- values
-
Array<Excel.Range | Excel.RangeReference | Excel.FunctionResult
| 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
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
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, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, per: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the initial cost of the asset.
- salvage
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of the life of the asset.
- life
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the period and must use the same units as Life.
Returns
Remarks
t_Dist_2T(x, degFreedom)
Returns the two-tailed Student's t-distribution.
t_Dist_2T(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numeric value at which to evaluate the distribution.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an integer indicating the number of degrees of freedom that characterize the distribution.
Returns
Remarks
t_Dist_RT(x, degFreedom)
Returns the right-tailed Student's t-distribution.
t_Dist_RT(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numeric value at which to evaluate the distribution.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an integer indicating the number of degrees of freedom that characterize the distribution.
Returns
Remarks
t_Dist(x, degFreedom, cumulative)
Returns the left-tailed Student's t-distribution.
t_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the numeric value at which to evaluate the distribution.
- degFreedom
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is an integer indicating the number of degrees of freedom that characterize the distribution.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability density function, use FALSE.
Returns
Remarks
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, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a positive integer indicating the number of degrees of freedom to characterize the distribution.
Returns
Remarks
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, degFreedom: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- probability
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a positive integer indicating the number of degrees of freedom to characterize the distribution.
Returns
Remarks
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): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to test.
Returns
Remarks
tan(number)
Returns the tangent of an angle.
tan(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the angle in radians for which you want the tangent. Degrees * PI()/180 = radians.
Returns
Remarks
tanh(number)
Returns the hyperbolic tangent of a number.
tanh(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is any real number.
Returns
Remarks
tbillEq(settlement, maturity, discount)
Returns the bond-equivalent yield for a treasury bill.
tbillEq(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's maturity date, expressed as a serial date number.
- discount
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's discount rate.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, discount: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's maturity date, expressed as a serial date number.
- discount
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's discount rate.
Returns
Remarks
tbillYield(settlement, maturity, pr)
Returns the yield for a treasury bill.
tbillYield(settlement: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury bill's maturity date, expressed as a serial date number.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Treasury Bill's price per $100 face value.
Returns
Remarks
text(value, formatText)
Converts a value to text in a specific number format.
text(value: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, formatText: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- value
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is a number format in text form from the Category box on the Number tab in the Format Cells dialog box.
Returns
Remarks
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, minute: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, second: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- hour
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number from 0 to 23 representing the hour.
- minute
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number from 0 to 59 representing the minute.
- second
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number from 0 to 59 representing the second.
Returns
Remarks
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): FunctionResult; Parameters
- timeText
-
string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
today()
Returns the current date formatted as a date.
today(): FunctionResult; Returns
Remarks
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's 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): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text from which you want spaces removed.
Returns
Remarks
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, percent: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the range or array of values to trim and average.
- percent
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the fractional number of data points to exclude from the top and bottom of the data set.
Returns
Remarks
true()
Returns the logical value TRUE.
true(): FunctionResult; Returns
Remarks
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, numDigits?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number you want to truncate.
- numDigits
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number specifying the precision of the truncation, 0 (zero) if omitted.
Returns
Remarks
type(value)
Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64; compound data = 128.
type(value: boolean | string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- value
-
boolean | string | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Can be any value.
Returns
Remarks
unichar(number)
Returns the Unicode character referenced by the given numeric value.
unichar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the Unicode number representing a character.
Returns
Remarks
unicode(text)
Returns the number (code point) corresponding to the first character of the text.
unicode(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the character that you want the Unicode value of.
Returns
Remarks
upper(text)
Converts a text string to all uppercase letters.
upper(text: string | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text you want converted to uppercase, a reference or a text string.
Returns
Remarks
usdollar(number, decimals)
Converts a number to text, using currency format.
usdollar(number: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, decimals?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- number
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Is the number of digits to the right of the decimal point.
Returns
Remarks
value(text)
Converts a text string that represents a number to a number.
value(text: string | boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- text
-
string | boolean | number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
Returns
Remarks
var_P(values)
Calculates variance based on the entire population (ignores logical values and text in the population).
var_P(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numeric arguments corresponding to a population.
Returns
Remarks
var_S(values)
Estimates variance based on a sample (ignores logical values and text in the sample).
var_S(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 numeric arguments corresponding to a sample of a population.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 value arguments corresponding to a sample of a population.
Returns
Remarks
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>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
List of parameters, whose elements are 1 to 255 value arguments corresponding to a population.
Returns
Remarks
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, salvage: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, life: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, startPeriod: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, endPeriod: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, factor?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, noSwitch?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- cost
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the initial cost of the asset.
- salvage
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the salvage value at the end of the life of the asset.
- life
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
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
Is the rate at which the balance declines, 2 (double-declining balance) if omitted.
- noSwitch
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Switch to straight-line depreciation when depreciation is greater than the declining balance = FALSE or omitted; do not switch = TRUE.
Returns
Remarks
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, tableArray: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, colIndexNum: Excel.Range | number | Excel.RangeReference | Excel.FunctionResult, rangeLookup?: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- lookupValue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
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
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
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
Remarks
Examples
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/50-workbook/workbook-built-in-functions.yaml
await Excel.run(async (context) => {
// This function uses VLOOKUP to find data in the "Wrench" row on the worksheet.
let range = context.workbook.worksheets.getItem("Sample").getRange("A1:D4");
// Get the value in the second column in the "Wrench" row.
let unitSoldInNov = context.workbook.functions.vlookup("Wrench", range, 2, false);
unitSoldInNov.load("value");
await context.sync();
console.log(" Number of wrenches sold in November = " + unitSoldInNov.value);
});
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, returnType?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number that represents a date.
- returnType
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
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
Remarks
weekNum(serialNumber, returnType)
Returns the week number in the year.
weekNum(serialNumber: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, returnType?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the date-time code used by Microsoft Excel for date and time calculation.
- returnType
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number (1 or 2) that determines the type of the return value.
Returns
Remarks
weibull_Dist(x, alpha, beta, cumulative)
Returns the Weibull distribution.
weibull_Dist(x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, alpha: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, beta: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, cumulative: boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value at which to evaluate the function, a nonnegative number.
- alpha
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution, a positive number.
- beta
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a parameter to the distribution, a positive number.
- cumulative
-
boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.
Returns
Remarks
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, days: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, weekend?: number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- days
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of nonweekend and non-holiday days before or after startDate.
- weekend
-
number | string | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number or string specifying when weekends occur.
- holidays
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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, days: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, holidays?: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- days
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of nonweekend and non-holiday days before or after startDate.
- holidays
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
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
Remarks
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, dates: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult, guess?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- values
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
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
Is a schedule of payment dates that corresponds to the cash flow payments.
- guess
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number that you guess is close to the result of XIRR.
Returns
Remarks
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, values: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult, dates: number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the discount rate to apply to the cash flows.
- values
-
number | string | Excel.Range | boolean | Excel.RangeReference | Excel.FunctionResult
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
Is a schedule of payment dates that corresponds to the cash flow payments.
Returns
Remarks
xor(values)
Returns a logical 'Exclusive Or' of all arguments.
xor(...values: Array>): FunctionResult; Parameters
- values
-
Array
Excel.Range | Excel.RangeReference | Excel.FunctionResult >
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
Remarks
year(serialNumber)
Returns the year of a date, an integer in the range 1900 - 9999.
year(serialNumber: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- serialNumber
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a number in the date-time code used by Microsoft Excel.
Returns
Remarks
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, endDate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- startDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the start date.
- endDate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is a serial date number that represents the end date.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, frequency: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's annual coupon rate.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's price per $100 face value.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- frequency
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the number of coupon payments per year.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, redemption: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's price per $100 face value.
- redemption
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's redemption value per $100 face value.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, maturity: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, issue: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, rate: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, pr: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult, basis?: number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- settlement
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's settlement date, expressed as a serial date number.
- maturity
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's maturity date, expressed as a serial date number.
- issue
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's issue date, expressed as a serial date number.
- rate
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's interest rate at date of issue.
- pr
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the security's price per $100 face value.
- basis
-
number | string | boolean | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the type of day count basis to use.
Returns
Remarks
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, x: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult, sigma?: number | Excel.Range | Excel.RangeReference | Excel.FunctionResult): FunctionResult; Parameters
- array
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the array or range of data against which to test X.
- x
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the value to test.
- sigma
-
number | Excel.Range | Excel.RangeReference | Excel.FunctionResult
Is the population (known) standard deviation. If omitted, the sample standard deviation is used.