Worksheet Functions

Used as a container for Microsoft Excel worksheet functions that can be called through JavaScript or REST.

Return Type

Worksheet functions returns a FunctionResult Object. A FunctionResult Object has two properties.

Property Type Description Notes
value string Return the result of applying the worksheet function specified.
error string Return the error information when applying the worksheet functions specified.

Syntax

workbook.functions.functionMethod();

Examples

Here's a sample table tracking sales of different tools in Excel. We will use the data in this table to explain how worksheet functions work.

Sample

The following example will apply vlookup function to the table above and find the unit of Wrench sold in November.

    Excel.run(function (ctx) {
        var range = ctx.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");
        var unitSoldInNov = ctx.workbook.functions.vlookup("Wrench", range, 2, false);
        unitSoldInNov.load();
        return ctx.sync()
        .then(function () {
            console.log(unitSoldInNov.value);
        });
    })
    .catch(function(error) {
        console.log("Error: " + error);
        if (error instanceof OfficeExtension.Error) {
            console.log("Debug info: " + JSON.stringify(error.debugInfo));
        }
    });

The following example will use vlookup function to first find the unit of Wrench sold in November and December seperately. Then apply sum function to get the sum of units sold within these two months. Please note you only need to load the final result, any intermeidate result will be calculated and used when applying the final formula.

    Excel.run(function (ctx) {
        var range = ctx.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");
        var sumOfTwoLookups = ctx.workbook.functions.sum(
            ctx.workbook.functions.vlookup("Wrench", range, 2, false), 
            ctx.workbook.functions.vlookup("Wrench", range, 3, false)
            );
        sumOfTwoLookups.load();
        return ctx.sync()
        .then(function () {
            console.log(sumOfTwoLookups.value);
        });
    })
    .catch(function(error) {
        console.log("Error: " + error);
        if (error instanceof OfficeExtension.Error) {
            console.log("Debug info: " + JSON.stringify(error.debugInfo));
        }
    });


List of Supported Worksheet Functions

Method Return Type Description Notes
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 function 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 function 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 function FunctionResult Rounds a number down, toward zero  
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.  
FORECAST function FunctionResult Returns a value along a linear trend  
FORECAST.ETS function FunctionResult Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm  
FORECAST.ETS.CONFINT function FunctionResult Returns a confidence interval for the forecast value at the specified target date  
FORECAST.ETS.SEASONALITY function FunctionResult Returns the length of the repetitive pattern Excel detects for the specified time series  
FORECAST.ETS.STAT function FunctionResult Returns a statistical value as a result of time series forecasting  
FORECAST.LINEAR function FunctionResult Returns a future value based on existing values  
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  
PROB function FunctionResult Returns the probability that values in a range are between two limits  
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  
RTD function FunctionResult Retrieves real-time data from a program that supports COM automation  
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