Execute Formula functions (alphabetical)

Click a letter to go to functions that start with it. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To find functions by category, see Execute Formula functions (by category).

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

The Execute Formula transform supports a subset of functions from the Excel functions library. Where Excel function arguments sometimes accept ranges of cells in rows (such as A2:E2), ranges of cells in columns (such as A2:A5), or blocks of cells on a spreadsheet (such as A2:E5), the Execute Formula function arguments only accept ranges of columns (such as [Col2]:[Col5]).

To view detailed information for Excel functions, refer to Excel functions (alphabetical) or Excel functions (by category) at the Microsoft web site.

ABS function: Math and trigonometry: Returns the absolute value of a number.
ACOS function: Math and trigonometry: Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to π
ACOSH function: Math and trigonometry: Returns the inverse hyperbolic cosine of a number.
ADDRESS function: Lookup and reference: Returns a reference as text to a single cell in a dataset.
AND function: Logical: Returns Boolean true if all of its arguments are TRUE.
AREAS function: Lookup and reference: Returns the number of areas in a reference.
ASIN function: Math and trigonometry: Returns the arcsine, or inverse sine, of a number.
ASINH function: Math and trigonometry: Returns the inverse hyperbolic sine of a number.
ATAN function: Math and trigonometry: Returns the arctangent, or inverse tangent, of a number.
ATAN2 function: Math and trigonometry: Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
ATANH function: Math and trigonometry: Returns the inverse hyperbolic tangent of a number.
AVEDEV function: Statistical: Returns the average of the absolute deviations of data points from their mean.
AVERAGE function: Statistical: Returns the average of the its arguments.

CEILING function: Math and trigonometry: Rounds a number to the nearest integer or to the nearest multiple of significance.
CHAR function: String: Returns the character specified by a number.
CHOOSE function: Lookup and reference: Chooses a value from a list of values.
CLEAN function: String: Removes all unprintable characters from text.
CODE function: String: Returns a numeric code for the first character in a text string.
COLUMN function: Lookup and reference: Returns the column number of a reference.
COLUMNS function: Lookup and reference: Returns the number of columns in a reference.
COMBIN function: Math and trigonometry: Returns the number of combinations for a given number of objects.
CONCAT function: String: Joins several text items into one text item.
CONCATENATE function: String: Joins several text items into one text item.
COS function: Math and trigonometry: Returns the cosine of a number.
COSH function: Math and trigonometry: Returns the hyperbolic cosine of a number.
COUNT function: Statistical: Counts how many numbers are in the list of arguments.
COUNTA function: Statistical: Counts how many fields are not empty in a range.
COUNTBLANK function: Statistical: Counts the number of blank fields within a range.
COUNTIF function: Statistical: Counts the number of fields within a range that meet the given criteria.

DATE function: Date and time: Returns the sequential serial number that represents a particular date.
DATEVALUE function: Date and time: Converts a date in the form of text to a serial number.
DAY function: Date and time: Converts a serial number to a day of the month.
DAYS360 function: Date and time: Calculates the number of days between two dates based on a 360-day year.
DEGREES function: Math and trigonometry: Converts radians to degrees.
DEVSQ function: Statistical: Returns the sum of squares of deviations from a sample mean.
DGET function: Database: Extracts from a database a single record that matches the specified criteria.
DMAX function: Database: Returns the maximum value from selected database entries.
DMIN function: Database: Returns the minimum value from selected database entries.
DSUM function: Database: Adds the numbers in the field column of records in the database that match the criteria.

ERROR.TYPE function: Informational: Returns a number corresponding to an error type.
EVEN function: Math and trigonometry: Rounds a number up to the nearest even integer.
EXACT function: String: Checks to see if two text values are identical.
EXP function: Math and trigonometry: Returns the mathematical constant e raised to the power of a given number. The constant e is approximately equal to 2.71828182845904, the base of the natural logarithms. It is also the limit of (1 + 1/n)ⁿ as n approaches infinity.

FACT function: Math and trigonometry: Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...*number
FALSE function: Logical: Returns the logical value FALSE.
FIND function: String: Finds one text value within another (case-sensitive).
FIXED function: String: Formats a number as text with a fixed number of decimals.
FLOOR function: Math and trigonometry: Rounds a number down, toward zero.
FREQUENCY function: Statistical: Returns a frequency distribution as an array.
FV function: Financial: Returns the future value of an investment based on a constant interest rate.

GEOMEAN function: Statistical: Returns the geometric mean of a range of positive data.

HLOOKUP function: Lookup and reference: Looks in the top row of an array and returns the value of the indicated cell.
HOUR function: Date and time: Converts a serial number to an hour.

IF function: Logical: Specifies a value returned if an expression is true or false.
INTERCEPT function: Statistical: Returns the intercept of the linear regression line.
IPMT function: Financial: Returns the interest payment for an investment for a given period.
ISBLANK function: Informational: Returns TRUE if the value is blank.
ISERR function: Informational: Returns TRUE if the value is any error value except #N/A.
ISERROR function: Informational: Returns TRUE if the value is any error value.
ISLOGICAL function: Informational: Returns TRUE if the value is a logical value.
ISNA function: Informational: Returns TRUE if the value is the #N/A error value.
ISNONTEXT function: Informational: Returns true if the value is not text.
ISNUMBER function: Informational: Returns TRUE if the value is a number.
ISREF function: Informational: Returns TRUE if the value is a reference.
ISTEXT function: Informational: Returns TRUE if the value is text.

LARGE function: Statistical: Returns the k-th largest value in a data set.
LN function: Math and trigonometry: Returns the natural logarithm of a number.
LOG function: Math and trigonometry: Returns the logarithm of a number to a specified base (default is 10).
LOG10 function: Math and trigonometry: Returns the base-10 logarithm of a number.
LOOKUP function: Lookup and reference: Use this function when you need to look in a single row or column and find a value from the same position in a second row or column.
LOWER function: String: Converts text to lowercase.

MATCH function: Lookup and reference: Looks up values in a reference or array.
MAX function: Math and trigonometry: Returns the maximum value in a set of values.
MAXA function: Math and trigonometry: Returns the maximum value in a list of arguments, including numbers, text, and logical values.
MDETERM function: Math and trigonometry: Returns the matrix determinant of an array.
MEDIAN function: Math and trigonometry: Returns the median of the given numbers.
MID function: String: Returns a specific number of characters from a text string starting at the position you specify.
MIN function: Math and trigonometry: Returns the minimum value in a list of arguments.
MINA function: Math and trigonometry: Returns the smallest value in a list of arguments, including numbers, text, and logical values.
MINUTE function: Date and time: Converts a serial number to a minute.
MINVERSE function: Math and trigonometry: Returns the matrix inverse of an array.
MIRR function: Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates.
MMULT function: Math and trigonometry: Returns the matrix product of two arrays.
MOD function: Math and trigonometry: Returns the remainder from division.
MODE function: Math and trigonometry: Returns the most frequently occurring number in a numeric data set.
MONTH function: Date and time: Converts a serial number to a month.

NA function: Informational: Returns the error value #N/A.
NOT function: Logical: Reverses the logic of its argument.
NOW function: Date and time: Returns the serial number of the current date and time.
NPER function: Financial: Returns the number of periods for an investment.
NPV function: Financial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

ODD function: Math and trigonometry: Rounds a number up to the nearest odd integer.
OFFSET function: Lookup and reference: Returns a reference offset from a given reference.
OR function: Logical: Returns TRUE if any argument is TRUE.

PERCENTILE function: Statistical: Returns the k-th percentile of values in a range.
PERCENTRANK function: Statistical: Returns the rank of a value in a data set as a percentage of the data set.
PI function: Math and trigonometry: Returns the value of π (or pi).
PMT function: Financial: Returns the periodic payment for an annuity.
POISSON function: Statistical: Returns the Poisson distribution.
POWER function: Math and trigonometry: Returns the result of a number raised to a power.
PPMT function: Financial: Returns the payment on the principal for an investment for a given period.
PRODUCT function: Math and trigonometry: Multiplies the arguments.
PROPER function: String: Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter, such as a space. Converts all other letters to lowercase.
PV function: Financial: Returns the present value of an investment.Returns the present value of an investment.

RADIANS function: Math and trigonometry: Converts degrees to radians.
RAND function: Math and trigonometry: Returns a random number between 0 and 1.
RANK function: Statistical: Returns the rank of a number in a list of numbers.
RATE function: Financial: Returns the interest rate per period of an annuity.
REPLACE function: String: Replaces characters in text.
REPT function: String: Repeats text a given number of times.
RIGHT function: String: Returns the rightmost characters from a text value.
ROMAN function: Math and trigonometry: Converts an Arabic numeral to Roman, as text.
ROUND function: Math and trigonometry: Rounds a number to a specified number of digits.
ROUNDDOWN function: Math and trigonometry: Rounds a number down, toward zero.
ROUNDUP function: Math and trigonometry: Rounds a number up, away from zero.
ROW function: Lookup and reference: Returns the row number of a reference.
ROWS function: Lookup and reference: Returns the number of rows in a reference.

SEARCH function: String: Finds one text value within another (not case-sensitive).
SECOND function: Date and time: Converts a serial number to a second.
SIGN function: Math and trigonometry: Returns the sign of a number.
SIN function: Math and trigonometry: Returns the sine of the given angle.
SINH function: Math and trigonometry: Returns the hyperbolic sine of a number.
SLOPE function: Statistical: Returns the slope of the linear regression line.
SMALL function: Statistical: Returns the k-th smallest value in a data set.
SQRT function: Math and trigonometry: Returns a positive square root.
STDEV function: Statistical: Estimates standard deviation based on a sample.
SUBSTITUTE function: String: Substitutes new text for old text in a text string.
SUBTOTAL function: Math and trigonometry: Returns a subtotal of a list.
SUM function: Math and trigonometry: Sums its arguments.
SUMIF function: Math and trigonometry: Adds the cells specified by a given criteria.
SUMPRODUCT function: Math and trigonometry: Returns the sum of the products of corresponding array components.
SUMSQ function: Math and trigonometry: Returns the sum of the squares of the arguments.
SUMX2MY2 function: Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2 function: Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays.
SUMXMY2 function: Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays.

T function: String: Returns the text referred to by value.
TAN function: Math and trigonometry: Returns the tangent of a number.
TANH function: Math and trigonometry: Returns the hyperbolic tangent of a number.
TDIST function: Statistical: Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed.
TEXT function: String: Formats a number and converts it to text.
TIME function: Date and time: Returns the serial number of a particular time.
TIMEVALUE function: Date and time: Converts a time in the form of text to a serial number.
TODAY function: Date and time: Returns the serial number of today's date.
TRANSPOSE function: Lookup and reference: Returns the transpose of an array.
TREND function: Statistical: Returns values along a linear trend.
TRIM function: String: Removes all blank, unnecessary spaces at the start and end of a string including extra spaces, tabs, and other characters that do not print.
TRUE function: Logical: Returns the logical value TRUE.
TRUNC function: Math and trigonometry: Truncates a number to an integer.

UPPER function: String: Converts all text in a string to upper case.

VALUE function: String: Converts a text argument to a number.
VARP function: Statistical: Calculates variance based on the entire population.
VLOOKUP function: Lookup and reference: Looks in the first column of an array and moves across the row to return the value of a cell.

WEEKDAY function: Date and time: Converts a serial number to a day of the week.

YEAR function: Date and time: