Excel Add ins with js

Excel.run

Excel.run executes a function where you specify the actions to perform against the Excel object model. Excel.run automatically creates a request context that you can use to interact with Excel objects. When Excel.run completes, a promise is resolved, and any objects that were allocated at runtime are automatically released.

The following example shows how to use Excel.run. The catch statement catches and logs errors that occur within the Excel.run.

Excel.run(function (context) {

    // You can use the Excel JavaScript API here in the batch function

    // to execute actions on the Excel object model.

    console.log('Your code goes here.');

}).catch(function (error) {

    console.log('error: ' + error);

    if (error instanceof OfficeExtension.Error) {

        console.log('Debug info: ' + JSON.stringify(error.debugInfo));

    }

});

Calling built-in functions

Excel.run(function (context) {

    var range = context.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");

    var unitSoldInNov = context.workbook.functions.vlookup("Wrench", range, 2, false);

    unitSoldInNov.load('value');

    return context.sync()

        .then(function () {

            console.log(' Number of wrenches sold in November = ' + unitSoldInNov.value);

        });

}).catch(errorHandlerFunction);

Nested functions

Excel.run(function (context) {

    var range = context.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");

    var sumOfTwoLookups = context.workbook.functions.sum(

        context.workbook.functions.vlookup("Wrench", range, 2, false),

        context.workbook.functions.vlookup("Wrench", range, 3, false)

    );

    sumOfTwoLookups.load('value');

    return context.sync()

        .then(function () {

            console.log(' Number of wrenches sold in November and December = ' + sumOfTwoLookups.value);

        });

}).catch(errorHandlerFunction);

Function	Return type	Description
ABS function	FunctionResult	Returns the absolute value of a number
ACCRINT function	FunctionResult	Returns the accrued interest for a security that pays periodic interest
ACCRINTM function	FunctionResult	Returns the accrued interest for a security that pays interest at maturity
ACOS function	FunctionResult	Returns the arccosine of a number
ACOSH function	FunctionResult	Returns the inverse hyperbolic cosine of a number
ACOT function	FunctionResult	Returns the arccotangent of a number
ACOTH function	FunctionResult	Returns the hyperbolic arccotangent of a number
AMORDEGRC function	FunctionResult	Returns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC function	FunctionResult	Returns the depreciation for each accounting period
AND function	FunctionResult	Returns TRUE if all of its arguments are true
ARABIC function	FunctionResult	Converts a Roman number to Arabic, as a number
AREAS function	FunctionResult	Returns the number of areas in a reference
ASC function	FunctionResult	Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASIN function	FunctionResult	Returns the arcsine of a number
ASINH function	FunctionResult	Returns the inverse hyperbolic sine of a number
ATAN function	FunctionResult	Returns the arctangent of a number
ATAN2 function	FunctionResult	Returns the arctangent from x- and y-coordinates
ATANH function	FunctionResult	Returns the inverse hyperbolic tangent of a number
AVEDEV function	FunctionResult	Returns the average of the absolute deviations of data points from their mean
AVERAGE function	FunctionResult	Returns the average of its arguments
AVERAGEA function	FunctionResult	Returns the average of its arguments, including numbers, text, and logical values
AVERAGEIF function	FunctionResult	Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS function	FunctionResult	Returns the average (arithmetic mean) of all cells that meet multiple criteria
BAHTTEXT function	FunctionResult	Converts a number to text, using the ß (baht) currency format
BASE function	FunctionResult	Converts a number into a text representation with the given radix (base)
BESSELI function	FunctionResult	Returns the modified Bessel function In(x)
BESSELJ function	FunctionResult	Returns the Bessel function Jn(x)
BESSELK function	FunctionResult	Returns the modified Bessel function Kn(x)
BESSELY function	FunctionResult	Returns the Bessel function Yn(x)
BETA.DIST function	FunctionResult	Returns the beta cumulative distribution function
BETA.INV function	FunctionResult	Returns the inverse of the cumulative distribution function for a specified beta distribution
BIN2DEC function	FunctionResult	Converts a binary number to decimal
BIN2HEX function	FunctionResult	Converts a binary number to hexadecimal
BIN2OCT function	FunctionResult	Converts a binary number to octal
BINOM.DIST function	FunctionResult	Returns the individual term binomial distribution probability
BINOM.DIST.RANGE function	FunctionResult	Returns the probability of a trial result using a binomial distribution
BINOM.INV function	FunctionResult	Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
BITAND function	FunctionResult	Returns a 'Bitwise And' of two numbers
BITLSHIFT function	FunctionResult	Returns a value number shifted left by shift_amount bits
BITOR function	FunctionResult	Returns a bitwise OR of 2 numbers
BITRSHIFT function	FunctionResult	Returns a value number shifted right by shift_amount bits
BITXOR function	FunctionResult	Returns a bitwise 'Exclusive Or' of two numbers
CEILING.MATH, ECMA_CEILING functions	FunctionResult	Rounds a number up, to the nearest integer or to the nearest multiple of significance
CEILING.PRECISE function	FunctionResult	Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
CHAR function	FunctionResult	Returns the character specified by the code number
CHISQ.DIST function	FunctionResult	Returns the cumulative beta probability density function
CHISQ.DIST.RT function	FunctionResult	Returns the one-tailed probability of the chi-squared distribution
CHISQ.INV function	FunctionResult	Returns the cumulative beta probability density function
CHISQ.INV.RT function	FunctionResult	Returns the inverse of the one-tailed probability of the chi-squared distribution
CHOOSE function	FunctionResult	Chooses a value from a list of values
CLEAN function	FunctionResult	Removes all nonprintable characters from text
CODE function	FunctionResult	Returns a numeric code for the first character in a text string
COLUMNS function	FunctionResult	Returns the number of columns in a reference
COMBIN function	FunctionResult	Returns the number of combinations for a given number of objects
COMBINA function	FunctionResult	Returns the number of combinations with repetitions for a given number of items
COMPLEX function	FunctionResult	Converts real and imaginary coefficients into a complex number
CONCATENATE function	FunctionResult	Joins several text items into one text item
CONFIDENCE.NORM function	FunctionResult	Returns the confidence interval for a population mean
CONFIDENCE.T function	FunctionResult	Returns the confidence interval for a population mean, using a Student's t distribution
CONVERT function	FunctionResult	Converts a number from one measurement system to another
COS function	FunctionResult	Returns the cosine of a number
COSH function	FunctionResult	Returns the hyperbolic cosine of a number
COT function	FunctionResult	Returns the cotangent of an angle
COTH function	FunctionResult	Returns the hyperbolic cotangent of a number
COUNT function	FunctionResult	Counts how many numbers are in the list of arguments
COUNTA function	FunctionResult	Counts how many values are in the list of arguments
COUNTBLANK function	FunctionResult	Counts the number of blank cells within a range
COUNTIF function	FunctionResult	Counts the number of cells within a range that meet the given criteria
COUNTIFS function	FunctionResult	Counts the number of cells within a range that meet multiple criteria
COUPDAYBS function	FunctionResult	Returns the number of days from the beginning of the coupon period to the settlement date
COUPDAYS function	FunctionResult	Returns the number of days in the coupon period that contains the settlement date
COUPDAYSNC function	FunctionResult	Returns the number of days from the settlement date to the next coupon date
COUPNCD function	FunctionResult	Returns the next coupon date after the settlement date
COUPNUM function	FunctionResult	Returns the number of coupons payable between the settlement date and maturity date
COUPPCD function	FunctionResult	Returns the previous coupon date before the settlement date
CSC function	FunctionResult	Returns the cosecant of an angle
CSCH function	FunctionResult	Returns the hyperbolic cosecant of an angle
CUMIPMT function	FunctionResult	Returns the cumulative interest paid between two periods
CUMPRINC function	FunctionResult	Returns the cumulative principal paid on a loan between two periods
DATE function	FunctionResult	Returns the serial number of a particular date
DATEVALUE function	FunctionResult	Converts a date in the form of text to a serial number
DAVERAGE function	FunctionResult	Returns the average of selected database entries
DAY function	FunctionResult	Converts a serial number to a day of the month
DAYS function	FunctionResult	Returns the number of days between two dates
DAYS360 function	FunctionResult	Calculates the number of days between two dates based on a 360-day year
DB function	FunctionResult	Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
DBCS function	FunctionResult	Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
DCOUNT function	FunctionResult	Counts the cells that contain numbers in a database
DCOUNTA function	FunctionResult	Counts nonblank cells in a database
DDB function	FunctionResult	Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DEC2BIN function	FunctionResult	Converts a decimal number to binary
DEC2HEX function	FunctionResult	Converts a decimal number to hexadecimal
DEC2OCT function	FunctionResult	Converts a decimal number to octal
DECIMAL function	FunctionResult	Converts a text representation of a number in a given base into a decimal number
DEGREES function	FunctionResult	Converts radians to degrees
DELTA function	FunctionResult	Tests whether two values are equal
DEVSQ function	FunctionResult	Returns the sum of squares of deviations
DGET function	FunctionResult	Extracts from a database a single record that matches the specified criteria
DISC function	FunctionResult	Returns the discount rate for a security
DMAX function	FunctionResult	Returns the maximum value from selected database entries
DMIN function	FunctionResult	Returns the minimum value from selected database entries
DOLLAR, USDOLLAR functions	FunctionResult	Converts a number to text, using the $ (dollar) currency format
DOLLARDE function	FunctionResult	Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFR function	FunctionResult	Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DPRODUCT function	FunctionResult	Multiplies the values in a particular field of records that match the criteria in a database
DSTDEV function	FunctionResult	Estimates the standard deviation based on a sample of selected database entries
DSTDEVP function	FunctionResult	Calculates the standard deviation based on the entire population of selected database entries
DSUM function	FunctionResult	Adds the numbers in the field column of records in the database that match the criteria
DURATION function	FunctionResult	Returns the annual duration of a security with periodic interest payments
DVAR function	FunctionResult	Estimates variance based on a sample from selected database entries
DVARP function	FunctionResult	Calculates variance based on the entire population of selected database entries
EDATE function	FunctionResult	Returns the serial number of the date that is the indicated number of months before or after the start date
EFFECT function	FunctionResult	Returns the effective annual interest rate
EOMONTH function	FunctionResult	Returns the serial number of the last day of the month before or after a specified number of months
ERF function	FunctionResult	Returns the error function
ERF.PRECISE function	FunctionResult	Returns the error function
ERFC function	FunctionResult	Returns the complementary error function
ERFC.PRECISE function	FunctionResult	Returns the complementary ERF function integrated between x and infinity
ERROR.TYPE function	FunctionResult	Returns a number corresponding to an error type
EVEN function	FunctionResult	Rounds a number up to the nearest even integer
EXACT function	FunctionResult	Checks to see if two text values are identical
EXP function	FunctionResult	Returns e raised to the power of a given number
EXPON.DIST function	FunctionResult	Returns the exponential distribution
F.DIST function	FunctionResult	Returns the F probability distribution
F.DIST.RT function	FunctionResult	Returns the F probability distribution
F.INV function	FunctionResult	Returns the inverse of the F probability distribution
F.INV.RT function	FunctionResult	Returns the inverse of the F probability distribution
FACT function	FunctionResult	Returns the factorial of a number
FACTDOUBLE function	FunctionResult	Returns the double factorial of a number
FALSE function	FunctionResult	Returns the logical value FALSE
FIND, FINDB functions	FunctionResult	Finds one text value within another (case-sensitive)
FISHER function	FunctionResult	Returns the Fisher transformation
FISHERINV function	FunctionResult	Returns the inverse of the Fisher transformation
FIXED function	FunctionResult	Formats a number as text with a fixed number of decimals
FLOOR.MATH function	FunctionResult	Rounds a number down, to the nearest integer or to the nearest multiple of significance
FLOOR.PRECISE function	FunctionResult	Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.
FV function	FunctionResult	Returns the future value of an investment
FVSCHEDULE function	FunctionResult	Returns the future value of an initial principal after applying a series of compound interest rates
GAMMA function	FunctionResult	Returns the Gamma function value
GAMMA.DIST function	FunctionResult	Returns the gamma distribution
GAMMA.INV function	FunctionResult	Returns the inverse of the gamma cumulative distribution
GAMMALN function	FunctionResult	Returns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISE function	FunctionResult	Returns the natural logarithm of the gamma function, Γ(x)
GAUSS function	FunctionResult	Returns 0.5 less than the standard normal cumulative distribution
GCD function	FunctionResult	Returns the greatest common divisor
GEOMEAN function	FunctionResult	Returns the geometric mean
GESTEP function	FunctionResult	Tests whether a number is greater than a threshold value
HARMEAN function	FunctionResult	Returns the harmonic mean
HEX2BIN function	FunctionResult	Converts a hexadecimal number to binary
HEX2DEC function	FunctionResult	Converts a hexadecimal number to decimal
HEX2OCT function	FunctionResult	Converts a hexadecimal number to octal
HLOOKUP function	FunctionResult	Looks in the top row of an array and returns the value of the indicated cell
HOUR function	FunctionResult	Converts a serial number to an hour
HYPERLINK function	FunctionResult	Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
HYPGEOM.DIST function	FunctionResult	Returns the hypergeometric distribution
IF function	FunctionResult	Specifies a logical test to perform
IMABS function	FunctionResult	Returns the absolute value (modulus) of a complex number
IMAGINARY function	FunctionResult	Returns the imaginary coefficient of a complex number
IMARGUMENT function	FunctionResult	Returns the argument theta, an angle expressed in radians
IMCONJUGATE function	FunctionResult	Returns the complex conjugate of a complex number
IMCOS function	FunctionResult	Returns the cosine of a complex number
IMCOSH function	FunctionResult	Returns the hyperbolic cosine of a complex number
IMCOT function	FunctionResult	Returns the cotangent of a complex number
IMCSC function	FunctionResult	Returns the cosecant of a complex number
IMCSCH function	FunctionResult	Returns the hyperbolic cosecant of a complex number
IMDIV function	FunctionResult	Returns the quotient of two complex numbers
IMEXP function	FunctionResult	Returns the exponential of a complex number
IMLN function	FunctionResult	Returns the natural logarithm of a complex number
IMLOG10 function	FunctionResult	Returns the base-10 logarithm of a complex number
IMLOG2 function	FunctionResult	Returns the base-2 logarithm of a complex number
IMPOWER function	FunctionResult	Returns a complex number raised to an integer power
IMPRODUCT function	FunctionResult	Returns the product of from 2 to 255 complex numbers
IMREAL function	FunctionResult	Returns the real coefficient of a complex number
IMSEC function	FunctionResult	Returns the secant of a complex number
IMSECH function	FunctionResult	Returns the hyperbolic secant of a complex number
IMSIN function	FunctionResult	Returns the sine of a complex number
IMSINH function	FunctionResult	Returns the hyperbolic sine of a complex number
IMSQRT function	FunctionResult	Returns the square root of a complex number
IMSUB function	FunctionResult	Returns the difference between two complex numbers
IMSUM function	FunctionResult	Returns the sum of complex numbers
IMTAN function	FunctionResult	Returns the tangent of a complex number
INT function	FunctionResult	Rounds a number down to the nearest integer
INTRATE function	FunctionResult	Returns the interest rate for a fully invested security
IPMT function	FunctionResult	Returns the interest payment for an investment for a given period
IRR function	FunctionResult	Returns the internal rate of return for a series of cash flows
ISERR function	FunctionResult	Returns TRUE if the value is any error value except #N/A
ISERROR function	FunctionResult	Returns TRUE if the value is any error value
ISEVEN function	FunctionResult	Returns TRUE if the number is even
ISFORMULA function	FunctionResult	Returns TRUE if there is a reference to a cell that contains a formula
ISLOGICAL function	FunctionResult	Returns TRUE if the value is a logical value
ISNA function	FunctionResult	Returns TRUE if the value is the #N/A error value
ISNONTEXT function	FunctionResult	Returns TRUE if the value is not text
ISNUMBER function	FunctionResult	Returns TRUE if the value is a number
ISO.CEILING function	FunctionResult	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance
ISODD function	FunctionResult	Returns TRUE if the number is odd
ISOWEEKNUM function	FunctionResult	Returns the number of the ISO week number of the year for a given date
ISPMT function	FunctionResult	Calculates the interest paid during a specific period of an investment
ISREF function	FunctionResult	Returns TRUE if the value is a reference
ISTEXT function	FunctionResult	Returns TRUE if the value is text
KURT function	FunctionResult	Returns the kurtosis of a data set
LARGE function	FunctionResult	Returns the k-th largest value in a data set
LCM function	FunctionResult	Returns the least common multiple
LEFT, LEFTB functions	FunctionResult	Returns the leftmost characters from a text value
LEN, LENB functions	FunctionResult	Returns the number of characters in a text string
LN function	FunctionResult	Returns the natural logarithm of a number
LOG function	FunctionResult	Returns the logarithm of a number to a specified base
LOG10 function	FunctionResult	Returns the base-10 logarithm of a number
LOGNORM.DIST function	FunctionResult	Returns the cumulative lognormal distribution
LOGNORM.INV function	FunctionResult	Returns the inverse of the lognormal cumulative distribution
LOOKUP function	FunctionResult	Looks up values in a vector or array
LOWER function	FunctionResult	Converts text to lowercase
MATCH function	FunctionResult	Looks up values in a reference or array
MAX function	FunctionResult	Returns the maximum value in a list of arguments
MAXA function	FunctionResult	Returns the maximum value in a list of arguments, including numbers, text, and logical values
MDURATION function	FunctionResult	Returns the Macauley modified duration for a security with an assumed par value of $100
MEDIAN function	FunctionResult	Returns the median of the given numbers
MID, MIDB functions	FunctionResult	Returns a specific number of characters from a text string starting at the position you specify
MIN function	FunctionResult	Returns the minimum value in a list of arguments
MINA function	FunctionResult	Returns the smallest value in a list of arguments, including numbers, text, and logical values
MINUTE function	FunctionResult	Converts a serial number to a minute
MIRR function	FunctionResult	Returns the internal rate of return where positive and negative cash flows are financed at different rates
MOD function	FunctionResult	Returns the remainder from division
MONTH function	FunctionResult	Converts a serial number to a month
MROUND function	FunctionResult	Returns a number rounded to the desired multiple
MULTINOMIAL function	FunctionResult	Returns the multinomial of a set of numbers
N function	FunctionResult	Returns a value converted to a number
NA function	FunctionResult	Returns the error value #N/A
NEGBINOM.DIST function	FunctionResult	Returns the negative binomial distribution
NETWORKDAYS function	FunctionResult	Returns the number of whole workdays between two dates
NETWORKDAYS.INTL function	FunctionResult	Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
NOMINAL function	FunctionResult	Returns the annual nominal interest rate
NORM.DIST function	FunctionResult	Returns the normal cumulative distribution
NORM.INV function	FunctionResult	Returns the inverse of the normal cumulative distribution
NORM.S.DIST function	FunctionResult	Returns the standard normal cumulative distribution
NORM.S.INV function	FunctionResult	Returns the inverse of the standard normal cumulative distribution
NOT function	FunctionResult	Reverses the logic of its argument
NOW function	FunctionResult	Returns the serial number of the current date and time
NPER function	FunctionResult	Returns the number of periods for an investment
NPV function	FunctionResult	Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
NUMBERVALUE function	FunctionResult	Converts text to number in a locale-independent manner
OCT2BIN function	FunctionResult	Converts an octal number to binary
OCT2DEC function	FunctionResult	Converts an octal number to decimal
OCT2HEX function	FunctionResult	Converts an octal number to hexadecimal
ODD function	FunctionResult	Rounds a number up to the nearest odd integer
ODDFPRICE function	FunctionResult	Returns the price per $100 face value of a security with an odd first period
ODDFYIELD function	FunctionResult	Returns the yield of a security with an odd first period
ODDLPRICE function	FunctionResult	Returns the price per $100 face value of a security with an odd last period
ODDLYIELD function	FunctionResult	Returns the yield of a security with an odd last period
OR function	FunctionResult	Returns TRUE if any argument is true
PDURATION function	FunctionResult	Returns the number of periods required by an investment to reach a specified value
PERCENTILE.EXC function	FunctionResult	Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive
PERCENTILE.INC function	FunctionResult	Returns the k-th percentile of values in a range
PERCENTRANK.EXC function	FunctionResult	Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
PERCENTRANK.INC function	FunctionResult	Returns the percentage rank of a value in a data set
PERMUT function	FunctionResult	Returns the number of permutations for a given number of objects
PERMUTATIONA function	FunctionResult	Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI function	FunctionResult	Returns the value of the density function for a standard normal distribution
PI function	FunctionResult	Returns the value of pi
PMT function	FunctionResult	Returns the periodic payment for an annuity
POISSON.DIST function	FunctionResult	Returns the Poisson distribution
POWER function	FunctionResult	Returns the result of a number raised to a power
PPMT function	FunctionResult	Returns the payment on the principal for an investment for a given period
PRICE function	FunctionResult	Returns the price per $100 face value of a security that pays periodic interest
PRICEDISC function	FunctionResult	Returns the price per $100 face value of a discounted security
PRICEMAT function	FunctionResult	Returns the price per $100 face value of a security that pays interest at maturity
PRODUCT function	FunctionResult	Multiplies its arguments
PROPER function	FunctionResult	Capitalizes the first letter in each word of a text value
PV function	FunctionResult	Returns the present value of an investment
QUARTILE.EXC function	FunctionResult	Returns the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INC function	FunctionResult	Returns the quartile of a data set
QUOTIENT function	FunctionResult	Returns the integer portion of a division
RADIANS function	FunctionResult	Converts degrees to radians
RAND function	FunctionResult	Returns a random number between 0 and 1
RANDBETWEEN function	FunctionResult	Returns a random number between the numbers you specify
RANK.AVG function	FunctionResult	Returns the rank of a number in a list of numbers
RANK.EQ function	FunctionResult	Returns the rank of a number in a list of numbers
RATE function	FunctionResult	Returns the interest rate per period of an annuity
RECEIVED function	FunctionResult	Returns the amount received at maturity for a fully invested security
REPLACE, REPLACEB functions	FunctionResult	Replaces characters within text
REPT function	FunctionResult	Repeats text a given number of times
RIGHT, RIGHTB functions	FunctionResult	Returns the rightmost characters from a text value
ROMAN function	FunctionResult	Converts an Arabic numeral to Roman, as text
ROUND function	FunctionResult	Rounds a number to a specified number of digits
ROUNDDOWN function	FunctionResult	Rounds a number down, toward zero
ROUNDUP function	FunctionResult	Rounds a number up, away from zero
ROWS function	FunctionResult	Returns the number of rows in a reference
RRI function	FunctionResult	Returns an equivalent interest rate for the growth of an investment
SEC function	FunctionResult	Returns the secant of an angle
SECH function	FunctionResult	Returns the hyperbolic secant of an angle
SECOND function	FunctionResult	Converts a serial number to a second
SERIESSUM function	FunctionResult	Returns the sum of a power series based on the formula
SHEET function	FunctionResult	Returns the sheet number of the referenced sheet
SHEETS function	FunctionResult	Returns the number of sheets in a reference
SIGN function	FunctionResult	Returns the sign of a number
SIN function	FunctionResult	Returns the sine of the given angle
SINH function	FunctionResult	Returns the hyperbolic sine of a number
SKEW function	FunctionResult	Returns the skewness of a distribution
SKEW.P function	FunctionResult	Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
SLN function	FunctionResult	Returns the straight-line depreciation of an asset for one period
SMALL function	FunctionResult	Returns the k-th smallest value in a data set
SQRT function	FunctionResult	Returns a positive square root
SQRTPI function	FunctionResult	Returns the square root of (number * pi)
STANDARDIZE function	FunctionResult	Returns a normalized value
STDEV.P function	FunctionResult	Calculates standard deviation based on the entire population
STDEV.S function	FunctionResult	Estimates standard deviation based on a sample
STDEVA function	FunctionResult	Estimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPA function	FunctionResult	Calculates standard deviation based on the entire population, including numbers, text, and logical values
SUBSTITUTE function	FunctionResult	Substitutes new text for old text in a text string
SUBTOTAL function	FunctionResult	Returns a subtotal in a list or database
SUM function	FunctionResult	Adds its arguments
SUMIF function	FunctionResult	Adds the cells specified by a given criteria
SUMIFS function	FunctionResult	Adds the cells in a range that meet multiple criteria
SUMSQ function	FunctionResult	Returns the sum of the squares of the arguments
SYD function	FunctionResult	Returns the sum-of-years' digits depreciation of an asset for a specified period
T function	FunctionResult	Converts its arguments to text
T.DIST function	FunctionResult	Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.2T function	FunctionResult	Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.RT function	FunctionResult	Returns the Student's t-distribution
T.INV function	FunctionResult	Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
T.INV.2T function	FunctionResult	Returns the inverse of the Student's t-distribution
TAN function	FunctionResult	Returns the tangent of a number
TANH function	FunctionResult	Returns the hyperbolic tangent of a number
TBILLEQ function	FunctionResult	Returns the bond-equivalent yield for a Treasury bill
TBILLPRICE function	FunctionResult	Returns the price per $100 face value for a Treasury bill
TBILLYIELD function	FunctionResult	Returns the yield for a Treasury bill
TEXT function	FunctionResult	Formats a number and converts it to text
TIME function	FunctionResult	Returns the serial number of a particular time
TIMEVALUE function	FunctionResult	Converts a time in the form of text to a serial number
TODAY function	FunctionResult	Returns the serial number of today's date
TRIM function	FunctionResult	Removes spaces from text
TRIMMEAN function	FunctionResult	Returns the mean of the interior of a data set
TRUE function	FunctionResult	Returns the logical value TRUE
TRUNC function	FunctionResult	Truncates a number to an integer
TYPE function	FunctionResult	Returns a number indicating the data type of a value
UNICHAR function	FunctionResult	Returns the Unicode character that is references by the given numeric value
UNICODE function	FunctionResult	Returns the number (code point) that corresponds to the first character of the text
UPPER function	FunctionResult	Converts text to uppercase
VALUE function	FunctionResult	Converts a text argument to a number
VAR.P function	FunctionResult	Calculates variance based on the entire population
VAR.S function	FunctionResult	Estimates variance based on a sample
VARA function	FunctionResult	Estimates variance based on a sample, including numbers, text, and logical values
VARPA function	FunctionResult	Calculates variance based on the entire population, including numbers, text, and logical values
VDB function	FunctionResult	Returns the depreciation of an asset for a specified or partial period by using a declining balance method
VLOOKUP function	FunctionResult	Looks in the first column of an array and moves across the row to return the value of a cell
WEEKDAY function	FunctionResult	Converts a serial number to a day of the week
WEEKNUM function	FunctionResult	Converts a serial number to a number representing where the week falls numerically with a year
WEIBULL.DIST function	FunctionResult	Returns the Weibull distribution
WORKDAY function	FunctionResult	Returns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL function	FunctionResult	Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
XIRR function	FunctionResult	Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV function	FunctionResult	Returns the net present value for a schedule of cash flows that is not necessarily periodic
XOR function	FunctionResult	Returns a logical exclusive OR of all arguments
YEAR function	FunctionResult	Converts a serial number to a year
YEARFRAC function	FunctionResult	Returns the year fraction representing the number of whole days between start_date and end_date
YIELD function	FunctionResult	Returns the yield on a security that pays periodic interest
YIELDDISC function	FunctionResult	Returns the annual yield for a discounted security; for example, a Treasury bill
YIELDMAT function	FunctionResult	Returns the annual yield of a security that pays interest at maturity
Z.TEST function	FunctionResult	Returns the one-tailed probability-value of a z-test