Execute Formula functions (by category)

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.

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.

HOUR function

Date and time: Converts a serial number to an hour.

MINUTE function

Date and time: Converts a serial number to a minute.

MONTH function

Date and time: Converts a serial number to a month.

NOW function

Date and time: Returns the serial number of the current date and time.

SECOND function

Date and time: Converts a serial number to a second.

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.

WEEKDAY function

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

YEAR function

Date and time:

FV function

Financial: Returns the future value of an investment based on a constant interest rate.

IPMT function

Financial: Returns the interest payment for an investment for a given period.

MIRR function

Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates.

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.

PMT function

Financial: Returns the periodic payment for an annuity.

PPMT function

Financial: Returns the payment on the principal for an investment for a given period.

PV function

Financial: Returns the present value of an investment.Returns the present value of an investment.

RATE function

Financial: Returns the interest rate per period of an annuity.

Financial functions key

• fv—The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).
• Nper—The total number of payment periods in an annuity.
• per—The period for which you want to find the interest and must be in the range 1 to Nper.
• pmt—The payment made each period. it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.
• pv—The present value, or the lump-sum amount that a series of future payments is worth right now. The default is 0. If pv is omitted, you must include the pmt argument.
• rate—The interest rate per period.
• type—Optional. The number 0 or 1 and indicates when payments are due. The default is 0.

AND function

Logical: Returns Boolean true if all of its arguments are TRUE.

FALSE function

Logical: Returns the logical value FALSE.

IF function

Logical: Specifies a value returned if an expression is true or false.

NOT function

Logical: Reverses the logic of its argument.

OR function

Logical: Returns TRUE if any argument is TRUE.

TRUE function

Logical: Returns the logical value TRUE.

ERROR.TYPE function

Informational: Returns a number corresponding to an error type.

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.

NA function

Informational: Returns the error value #N/A.

ADDRESS function

Lookup and reference: Returns a reference as text to a single cell in a dataset.

AREAS function

Lookup and reference: Returns the number of areas in a reference.

CHOOSE function

Lookup and reference: Chooses a value from a list of values.

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.

HLOOKUP function

Lookup and reference: Looks in the top row of an array and returns the value of the indicated cell.

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.

MATCH function

Lookup and reference: Looks up values in a reference or array.

OFFSET function

Lookup and reference: Returns a reference offset from a given reference.

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.

TRANSPOSE function

Lookup and reference: Returns the transpose of an array.

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.

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.

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.

CEILING function

Math and trigonometry: Rounds a number to the nearest integer or to the nearest multiple of significance.

COMBIN function

Math and trigonometry: Returns the number of combinations for a given number of objects.

COS function

Math and trigonometry: Returns the cosine of a number.

COSH function

Math and trigonometry: Returns the hyperbolic cosine of a number.

DEGREES function

Math and trigonometry: Converts radians to degrees.

EVEN function

Math and trigonometry: Rounds a number up to the nearest even integer.

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

FLOOR function

Math and trigonometry: Rounds a number down, toward zero.

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.

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.

MEDIAN function

Math and trigonometry: Returns the median of the given numbers.

MDETERM function

Math and trigonometry: Returns the matrix determinant of an array.

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.

MINVERSE function

Math and trigonometry: Returns the matrix inverse of an array.

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.

ODD function

Math and trigonometry: Rounds a number up to the nearest odd integer.

PI function

Math and trigonometry: Returns the value of π (or pi).

POWER function

Math and trigonometry: Returns the result of a number raised to a power.

PRODUCT function

Math and trigonometry: Multiplies the arguments.

RADIANS function

Math and trigonometry: Converts degrees to radians.

RAND function

Math and trigonometry: Returns a random number between 0 and 1.

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.

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.

SQRT function

Math and trigonometry: Returns a positive square root.

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.

TAN function

Math and trigonometry: Returns the tangent of a number.

TANH function

Math and trigonometry: Returns the hyperbolic tangent of a number.

TRUNC function

Math and trigonometry: Truncates a number to an integer.

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.

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.

DEVSQ function

Statistical: Returns the sum of squares of deviations from a sample mean.

FREQUENCY function

Statistical: Returns a frequency distribution as an array.

GEOMEAN function

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

INTERCEPT function

Statistical: Returns the intercept of the linear regression line.

LARGE function

Statistical: Returns the k-th largest value in a data set.

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.

POISSON function

Statistical: Returns the Poisson distribution.

RANK function

Statistical: Returns the rank of a number in a list of numbers.

SLOPE function

Statistical: Returns the slope of the linear regression line.

SMALL function

Statistical: Returns the k-th smallest value in a data set.

STDEV function

Statistical: Estimates standard deviation based on a sample.

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.

TREND function

Statistical: Returns values along a linear trend.

VARP function

Statistical: Calculates variance based on the entire population.

CHAR function

String: Returns the character specified by a number.

CLEAN function

String: Removes all unprintable characters from text.

CODE function

String: Returns a numeric code for the first character in a text string.

CONCAT function

String: Joins several text items into one text item.

CONCATENATE function

String: Joins several text items into one text item.

EXACT function

String: Checks to see if two text values are identical.

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.

LOWER function

String: Converts text to lowercase.

MID function

String: Returns a specific number of characters from a text string starting at the position you specify.

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.

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.

SEARCH function

String: Finds one text value within another (not case-sensitive).

SUBSTITUTE function

String: Substitutes new text for old text in a text string.

T function

String: Returns the text referred to by value.

TEXT function

String: Formats a number and converts it to text.

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.

UPPER function

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

VALUE function

String: Converts a text argument to a number.