Functions | Category | Type | Brief |
DAVERAGE | Database | Built-in | Returns the average of selected database entries |
DCOUNT | Database | Built-in | Counts the cells that contain numbers in a database |
DCOUNTA | Database | Built-in | Counts nonblank cells in a database |
DGET | Database | Built-in | Extracts from a database a single record that matches the specified criteria |
DMAX | Database | Built-in | Returns the maximum value from selected database entries |
DMIN | Database | Built-in | Returns the minimum value from selected database entries |
DSUM | Database | Built-in | Adds the numbers in the field column of records in the database that match the criteria |
DATE | Date | Built-in | Returns the serial number of a particular date |
DATEDIF | Date | Built-in | Calculates the difference between two dates. Undocumented in v5/7/97 |
DATEVALUE | Date | Built-in | Converts a date in the form of text to a serial number |
DAY | Date | Built-in | Converts a serial number to a day of the month |
DAYS360 | Date | Built-in | Calculates the number of days between two dates based on a 360-day year |
EDATE | Date | Analysis ToolPak | Returns the serial number of the date that is the indicated number of months before or after the start date |
EOMONTH | Date | Analysis ToolPak | Returns the serial number of the last day of the month before or after a specified number of months |
HOUR | Date | Built-in | Converts a serial number to an hour |
MINUTE | Date | Built-in | Converts a serial number to a minute |
MONTH | Date | Built-in | Converts a serial number to a month |
NETWORKDAYS | Date | Analysis ToolPak | Returns the number of whole workdays between two dates |
NOW | Date | Built-in | Returns the serial number of the current date and time |
SECOND | Date | Built-in | Converts a serial number to a second |
TIME | Date | Built-in | Returns the serial number of a particular time |
TIMEVALUE | Date | Built-in | Converts a time in the form of text to a serial number |
TODAY | Date | Built-in | Returns the serial number of today's date |
WEEKDAY | Date | Built-in | Converts a serial number to a day of the week |
WORKDAY | Date | Analysis ToolPak | Returns the serial number of the date before or after a specified number of workdays |
YEAR | Date | Built-in | Converts a serial number to a year |
YEARFRAC | Date | Analysis ToolPak | Returns the year fraction representing the number of whole days between start_date and end_date |
BIN2DEC | Engineering | Analysis ToolPak | Converts a binary number to decimal |
CONVERT | Engineering | Analysis ToolPak | Converts a number from one measurement system to another |
DEC2BIN | Engineering | Analysis ToolPak | Converts a decimal number to binary |
DEC2HEX | Engineering | Analysis ToolPak | Converts a decimal number to hexadecimal |
DELTA | Engineering | Analysis ToolPak | Tests whether two values are equal |
GESTEP | Engineering | Analysis ToolPak | Tests whether a number is greater than a threshold value |
HEX2DEC | Engineering | Analysis ToolPak | Converts a hexadecimal number to decimal |
DB | Financial | Built-in | Returns the depreciation of an asset for a specified period using the fixed-declining balance method |
SLN | Financial | Built-in | Returns the straight-line depreciation of an asset for one period |
SYD | Financial | Built-in | Returns the sum-of-years' digits depreciation of an asset for a specified period |
CELL | Information | Built-in | Returns information about the formatting, location, or contents of a cell |
COUNTBLANK | Information | Built-in | Counts the number of blank cells within a range |
ERROR.TYPE | Information | Built-in | Returns a number corresponding to an error type |
INFO | Information | Built-in | Returns information about the current operating environment |
ISBLANK | Information | Built-in | Returns TRUE if the value is blank |
ISERR | Information | Built-in | Returns TRUE if the value is any error value except #N/A |
ISERROR | Information | Built-in | Returns TRUE if the value is any error value |
ISEVEN | Information | Analysis ToolPak | Returns TRUE if the number is even |
ISLOGICAL | Information | Built-in | Returns TRUE if the value is a logical value |
ISNA | Information | Built-in | Returns TRUE if the value is the #N/A error value |
ISNONTEXT | Information | Built-in | Returns TRUE if the value is not text |
ISNUMBER | Information | Built-in | Returns TRUE if the value is a number |
ISODD | Information | Analysis ToolPak | Returns TRUE if the number is odd |
ISREF | Information | Built-in | Returns TRUE if the value is a reference |
ISTEXT | Information | Built-in | Returns TRUE if the value is text |
N | Information | Built-in | Returns a value converted to a number |
NA | Information | Built-in | Returns the error value #N/A |
TYPE | Information | Built-in | Returns a number indicating the data type of a value |
AND | Logical | Built-in | Returns TRUE if all its arguments are TRUE |
IF | Logical | Built-in | Specifies a logical test to perform |
NOT | Logical | Built-in | Reverses the logic of its argument |
OR | Logical | Built-in | Returns TRUE if any argument is TRUE |
CHOOSE | Lookup | Built-in | Chooses a value from a list of values |
HLOOKUP | Lookup | Built-in | Looks in the top row of an array and returns the value of the indicated cell |
INDEX | Lookup | Built-in | Uses an index to choose a value from a reference or array |
INDIRECT | Lookup | Built-in | Returns a reference indicated by a text value |
LOOKUP (vector) | Lookup | Built-in | Looks up values in a vector or array |
MATCH | Lookup | Built-in | Looks up values in a reference or array |
SUM_with_OFFSET | Lookup | Built-in | Sample |
TRANSPOSE | Lookup | Built-in | Returns the transpose of an array |
VLOOKUP | Lookup | Built-in | Looks in the first column of an array and moves across the row to return the value of a cell |
ABS | Mathematical | Built-in | Returns the absolute value of a number |
CEILING | Mathematical | Built-in | Rounds a number to the nearest integer or to the nearest multiple of significance |
COMBIN | Mathematical | Built-in | Returns the number of combinations for a given number of objects |
COUNTIF | Mathematical | Built-in | Counts the number of nonblank cells within a range that meet the given criteria |
EVEN | Mathematical | Built-in | Rounds a number up to the nearest even integer |
FACT | Mathematical | Built-in | Returns the factorial of a number |
FLOOR | Mathematical | Built-in | Rounds a number down, toward zero |
GCD | Mathematical | Analysis ToolPak | Returns the greatest common divisor |
INT | Mathematical | Built-in | Rounds a number down to the nearest integer |
LCM | Mathematical | Analysis ToolPak | Returns the least common multiple |
MINVERSE | Mathematical | Built-in | Returns the matrix inverse of an array |
MMULT | Mathematical | Built-in | Returns the matrix product of two arrays |
MOD | Mathematical | Built-in | Returns the remainder from division |
MROUND | Mathematical | Analysis ToolPak | Returns a number rounded to the desired multiple |
ODD | Mathematical | Built-in | Rounds a number up to the nearest odd integer |
PI | Mathematical | Built-in | Returns the value of Pi |
POWER | Mathematical | Built-in | Returns the result of a number raised to a power |
PRODUCT | Mathematical | Built-in | Multiplies its arguments |
QUOTIENT | Mathematical | Analysis ToolPak | Returns the integer portion of a division |
RAND | Mathematical | Built-in | Returns a random number between 0 and 1 |
RANDBETWEEN | Mathematical | Analysis ToolPak | Returns a random number between the numbers you specify |
ROMAN | Mathematical | Built-in | Converts an arabic numeral to roman, as text |
ROUND | Mathematical | Built-in | Rounds a number to a specified number of digits |
ROUNDDOWN | Mathematical | Built-in | Rounds a number down, toward zero |
ROUNDUP | Mathematical | Built-in | Rounds a number up, away from zero |
SIGN | Mathematical | Built-in | Returns the sign of a number |
SUBTOTAL | Mathematical | Built-in | Returns a subtotal in a list or database |
SUM | Mathematical | Built-in | Adds its arguments |
SUM_as_Running_Total | Mathematical | Built-in | Sample |
SUMIF | Mathematical | Built-in | Adds the cells specified by a given criteria |
SUMPRODUCT | Mathematical | Built-in | Returns the sum of the products of corresponding array components |
TRUNC | Mathematical | Built-in | Truncates a number to an integer |
SUM_using_names | Sample | Sample | Using SUM(jan) |
-Timesheet | Sample | Sample | Sample |
AVERAGE | Statistical | Built-in | Returns the average of its arguments |
CORREL | Statistical | Built-in | Returns the correlation coefficient between two data sets |
COUNT | Statistical | Built-in | Counts how many numbers are in the list of arguments |
COUNTA | Statistical | Built-in | Counts how many values are in the list of arguments |
FORECAST | Statistical | Built-in | Returns a value along a linear trend |
FREQUENCY | Statistical | Built-in | Returns a frequency distribution as a vertical array |
GROWTH | Statistical | Built-in | Returns values along an exponential trend |
LARGE | Statistical | Built-in | Returns the k-th largest value in a data set |
MAX | Statistical | Built-in | Returns the maximum value in a list of arguments |
MEDIAN | Statistical | Built-in | Returns the median of the given numbers |
MIN | Statistical | Built-in | Returns the minimum value in a list of arguments |
MODE | Statistical | Built-in | Returns the most common value in a data set |
PERMUT | Statistical | Built-in | Returns the number of permutations for a given number of objects |
QUARTILE | Statistical | Built-in | Returns the quartile of a data set |
RANK | Statistical | Built-in | Returns the rank of a number in a list of numbers |
SMALL | Statistical | Built-in | Returns the k-th smallest value in a data set |
STDEV | Statistical | Built-in | Estimates standard deviation based on a sample |
STDEVP | Statistical | Built-in | Calculates standard deviation based on the entire population |
TREND | Statistical | Built-in | Returns values along a linear trend |
VAR | Statistical | Built-in | Estimates variance based on a sample |
VARP | Statistical | Built-in | Calculates variance based on the entire population |
CHAR | Text | Built-in | Returns the character specified by the code number |
CLEAN | Text | Built-in | Removes all nonprintable characters from text |
CODE | Text | Built-in | Returns a numeric code for the first character in a text string |
CONCATENATE | Text | Built-in | Joins several text items into one text item |
DOLLAR | Text | Built-in | Converts a number to text, using currency format |
EXACT | Text | Built-in | Checks to see if two text values are identical |
FIND | Text | Built-in | Finds one text value within another (case-sensitive) |
FIXED | Text | Built-in | Formats a number as text with a fixed number of decimals |
LEFT | Text | Built-in | Returns the leftmost characters from a text value |
LEN | Text | Built-in | Returns the number of characters in a text string |
LOWER | Text | Built-in | Converts text to lowercase |
MID | Text | Built-in | Returns a specific number of characters from a text string starting at the position you specify |
PROPER | Text | Built-in | Capitalises the first letter in each word of a text value |
REPLACE | Text | Built-in | Replaces characters within text |
REPT | Text | Built-in | Repeats text a given number of times |
RIGHT | Text | Built-in | Returns the rightmost characters from a text value |
SUBSTITUTE | Text | Built-in | Substitutes new text for old text in a text string |
T | Text | Built-in | Converts its arguments to text |
TEXT | Text | Built-in | Formats a number and converts it to text |
TRIM | Text | Built-in | Removes spaces from text |
UPPER | Text | Built-in | Converts text to uppercase |
VALUE | Text | Built-in | Converts a text argument to a number |