Grouped by category
These functions are sorted by category to make it easy to find related functions.
ABS returns the absolute value of a number.
ACOS returns the inverse trigonometric cosine of a number.
ADDRESS returns a cell address (reference) as text, according to the specified row and column numbers. Optionally, you can determine how the address is interpreted. The address can be interpreted as an absolute address (for example, $A$1), a relative address (as A1), or as a mixed form (A$1 or $A1). You can also specify the name of the sheet.
AND returns TRUE if all arguments are TRUE. If one of the elements is FALSE, this function returns the FALSE value.
ASIN returns the inverse trigonometric sine of a number.
ATAN returns the inverse trigonometric tangent of a number.
AVERAGE returns the average of the arguments.
AVERAGEA returns the average of the arguments. The value of a text is 0.
BASE converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used.
CEILING rounds a number up to the nearest multiple of significance.
COLUMN returns the column number of a cell reference.
COLUMNS returns the column number of a cell reference.
CONCATENATE combines several text strings into one string.
CONVERT converts a value from one unit of measurement to a different unit of measurement.
COUNT counts how many numbers are in the list of arguments. Text entries are ignored.
COUNTA counts how many values are in the list of arguments. Text entries are also counted, even when they contain an empty string of length 0. If an argument is an array or reference, empty cells within the array or reference are ignored.
COUNTBLANK returns the number of empty cells.
COUNTIF returns the number of cells that meet criteria within a cell range.
DATE converts a date written as year, month, day to an internal serial number and displays it in the formatting of the cell. The default format of a cell containing the DATE function is the date format. However, you can format the cells with the 0 number format, which displays the internal serial number of the date as a number. If the values for month and day are higher, they are carried over to the next digit. If you enter =DATE(00,12,31)
the result is 12/31/00
. However, if you enter =DATE(00,13,31)
the result is 1/31/01
Returns the number of years, months, or days between two dates.
DAY returns the day of a given date value. The day is returned as a value 1 - 31. You can also enter a negative date or time value.
DAYS calculates the difference between two date values. The result is an integer and returns the number of days between the two days.
ERRORTYPE returns the number corresponding to an error value occurring in a different cell. With the aid of this number, you can create an error message. If an error occurs, the function returns a logical or numerical value.
EVEN rounds a positive number up to the next even integer and a negative number down to the next even integer.
EXP returns e raised to the power of a number. The constant e has a value of approximately 2.71828182845904.
EXACT compares two text strings and returns TRUE if they are identical. This function is case-sensitive.
FACT returns the factorial of a number. Factorials are calculated as 1*2*3*4* ... * .
FALSE returns the logical value FALSE. The FALSE() function does not require any arguments, and always returns the logical value FALSE
FLOOR rounds a number down to the nearest multiple of significance.
FORMULA displays the formula of a formula cell at any position. The formula is returned as a string in the reference
position. If no formula cell can be found, or if the presented argument is not a reference, the error value #N/A
FREQUENCY indicates the frequency distribution in a set of values.
HLOOKUP searches for a value and reference to the cells under the selected area. This function verifies if the first row of an array contains a certain value. The function returns the value in a row of the array, which is named in the index, in the same column.
HOUR returns the hour for a given time value. The hour is returned as an integer 0 - 23.
HYPERLINK opens a hyperlink when you click the cell that contains the hyperlink. If you use the optional celltext
argument, the formula locates the URL, and then the text or number is displayed.
IF specifies a logical test to be performed.
INDEX returns the contents of a cell, specified by row and column number or an optional range name.
INDIRECT returns the reference specified by a text string. Use this function if you want a formula to always refer to a particular cell address, regardless of the contents of the cell after rows or cells have been moved or deleted. This function can also be used to return the area of a corresponding string.
Rounds a number down to the nearest integer. Negative numbers round down to the integer less than the number.
ISBLANK returns TRUE if the reference to a cell is blank. This function is used to determine if the content of a cell is empty. A cell with a formula inside is not empty. If an error occurs, the function returns a logical or numeric value.
ISERR returns TRUE if the value refers to any error value except #N/A. You can use this function to control error values in cells. If an error occurs, the function returns a logical or numeric value.
ISERROR tests if the cells contain general error values. ISERROR recognizes the #N/A error value. If the cell being referenced contains any error such as #N/A, #DIV/0 or #Err 522, it returns TRUE.
ISEVEN returns TRUE if the value is an even integer, or FALSE if the value is an odd integer.
ISFORMULA returns TRUE if a cell is a formula cell. If an error occurs, the function returns a logical or numeric value.
ISLOGICAL returns TRUE if the cell contains a logical number format. The function is used to check for both TRUE and FALSE values in cells. If an error occurs, the function returns a logical or numeric value.
ISNA returns TRUE if a cell contains the #N/A (value not available) error value. If an error occurs, the function returns a logical or numeric value.
ISNONTEXT tests if the cell contents are text or numbers, and returns FALSE if the contents are text. If an error occurs, the function returns a logical or numeric value.
ISNUMBER returns TRUE if the value refers to a number. If an error occurs, the function returns a logical or numerical value.
ISODD returns TRUE if the value is an odd integer, or FALSE if the number is an even integer.
ISREF tests if the content of one or several cells is a reference. This function verifies the type of references in a cell or a range of cells. If an error occurs, the function returns a logical or numerical value.
ISTEXT returns TRUE if the cell contents refer to text. If an error occurs, the function returns a logical or numeric value.
LARGE returns the nth largest value from a set of values.
LEFT returns the first character or characters in a text string.
LEN returns the length of a string including spaces.
LN returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904.
LOG returns the logarithm of a number to the specified base.
LOOKUP returns the contents of a cell either from a one-row or one-column range or from an array.
LOWER converts all uppercase letters in a text string to lowercase.
MAX returns the maximum value in a list of arguments.
MEDIAN returns the median (middle) value in the list.
Returns the specified portion of a string expression
MIN returns the minimum value in a list of arguments.
MINUTE calculates the minute for an internal time value. The minute is returned as a number 0 - 59.
MMULT calculates the array product of two arrays.
MOD returns the remainder when one integer is divided by another.
MODE returns the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when a value does not appear twice.
MONTH returns the month for the given date value. The month is returned as a number 1 - 12.
N returns the number 1 if the parameter is TRUE. N returns the parameter if the parameter is a number. N returns the number 0 for other parameters. If an error occurs, the function returns a logical or numerical value.
NA returns the error value #N/A.
NETWORKDAYS returns the number of workdays between the start date and the end date. Optionally, a list of holidays can be deducted.
NOT inverts and returns the logical value.
NOW returns the computer system date and time. The value is updated when you recalculate the document or each time that a cell value is modified.
ODD rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.
OFFSET returns the value of a cell the location of which is offset by a certain number of rows and columns.
OR returns TRUE if at least one argument is TRUE. This function returns the value FALSE only when all the arguments have the logical value FALSE.
PI returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.
POWER returns a number raised to a power.
PRODUCT multiplies all the numbers given as arguments and returns the product.
PROPER capitalizes the first letter in all words of a text string.
RAND returns a random number between 0 and 1.
RANDBETWEEN returns a random integer number in a specified range.
RANK returns the rank of a number in a sample.
REPLACE replaces part of a text string with a different text string. This function can be used to replace both characters and numbers, which are automatically converted to text. The result of the function is always displayed as text.
REPT repeats a character string by the given number of copies. The result can be a maximum of 255 characters.
RIGHT defines the last character or characters in a text string.
In languages that use the double-byte character set, RIGHTB returns the specified number of bytes at the end of a text string.
ROUND rounds a number to a number of decimal places. This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.
ROUNDDOWN rounds a number down, toward zero, to a certain precision. See ROUNDUP and ROUND for alternatives.
ROUNDUP rounds a number up, away from zero, to a certain precision. See ROUNDDOWN and ROUND for alternatives.
ROW returns the row number of a cell reference.
ROWS returns the number of rows in a reference or array.
SEARCH returns the position of a text segment within a character string. You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive.
SECOND returns the second for the given time value. The second is returned as an integer 0 - 59.
SHEET returns the sheet number of a reference or a string representing a sheet name. If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula.
SMALL returns the nth smallest value from a set of values.
SQRT returns the positive square root of a number.
STDEV estimates the standard deviation based on a sample.
STDEVP calculates the standard deviation based on the entire population.
SUBSTITUTE replaces old text with new text in a string.
SUBTOTAL calculates subtotals. If a range already contains subtotals, these are not used for further calculations.
SUM adds all the numbers in a range of cells.
SUMIF adds the cells specified by the given criteria. This function is used to browse a range when you search for a certain value.
SUMPRODUCT multiplies corresponding elements in the given arrays, and returns the sum of those products.
TEXT converts a number into text according to a given format.
TIME returns the current time value from values for hours, minutes, and seconds. This function can be used to convert a time based on these three elements to a decimal time value.
TODAY returns the current computer system date. The value is updated when you reopen the document or modify the values of the document.
TRIM removes spaces that are in front of a string, or aligns cell contents to the left.
TRUE returns the logical value TRUE. The TRUE() function does not require any arguments, and always returns the logical value TRUE.
TRUNC truncates a number by removing decimal places.
TYPE returns the type of value. If an error occurs, the function returns a logical or numeric value.
UPPER converts the string specified in the text
field to uppercase.
VLOOKUP uses a vertical search with reference to adjacent cells.
WEEKDAY returns the day of the week for the given date value. The day is returned as an integer between 1 and 7. The day of the week on which numbering begins depends on the type.
WEEKNUM calculates the week number of the year for the internal date value.
YEAR returns the year as a number according to the internal calculation rules.