Functions |
Category |
Type |
Brief |
ABS |
Mathematical |
Built-in |
Returns the absolute value of a number |
AND |
Logical |
Built-in |
Returns TRUE if all its arguments are TRUE |
AVERAGE |
Statistical |
Built-in |
Returns the average of its arguments |
BIN2DEC |
Engineering |
Analysis ToolPak |
Converts a binary number to decimal |
CEILING |
Mathematical |
Built-in |
Rounds a number to the nearest integer or to the nearest multiple of significance |
CELL |
Information |
Built-in |
Returns information about the formatting, location, or contents of a cell |
CHAR |
Text |
Built-in |
Returns the character specified by the code number |
CHOOSE |
Lookup |
Built-in |
Chooses a value from a list of values |
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 |
COMBIN |
Mathematical |
Built-in |
Returns the number of combinations for a given number of objects |
CONCATENATE |
Text |
Built-in |
Joins several text items into one text item |
CONVERT |
Engineering |
Analysis ToolPak |
Converts a number from one measurement system to another |
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 |
COUNTBLANK |
Information |
Built-in |
Counts the number of blank cells within a range |
COUNTIF |
Mathematical |
Built-in |
Counts the number of nonblank cells within a range that meet the given 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 |
DAVERAGE |
Database |
Built-in |
Returns the average of selected database entries |
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 |
DB |
Financial |
Built-in |
Returns the depreciation of an asset for a specified period using the fixed-declining balance method |
DCOUNT |
Database |
Built-in |
Counts the cells that contain numbers in a database |
DCOUNTA |
Database |
Built-in |
Counts nonblank cells in a database |
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 |
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 |
DOLLAR |
Text |
Built-in |
Converts a number to text, using currency format |
DSUM |
Database |
Built-in |
Adds the numbers in the field column of records in the database that match the criteria |
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 |
ERROR.TYPE |
Information |
Built-in |
Returns a number corresponding to an error type |
EVEN |
Mathematical |
Built-in |
Rounds a number up to the nearest even integer |
EXACT |
Text |
Built-in |
Checks to see if two text values are identical |
FACT |
Mathematical |
Built-in |
Returns the factorial of a number |
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 |
FLOOR |
Mathematical |
Built-in |
Rounds a number down, toward zero |
FORECAST |
Statistical |
Built-in |
Returns a value along a linear trend |
FREQUENCY |
Statistical |
Built-in |
Returns a frequency distribution as a vertical array |
GCD |
Mathematical |
Analysis ToolPak |
Returns the greatest common divisor |
GESTEP |
Engineering |
Analysis ToolPak |
Tests whether a number is greater than a threshold value |
GROWTH |
Statistical |
Built-in |
Returns values along an exponential trend |
HEX2DEC |
Engineering |
Analysis ToolPak |
Converts a hexadecimal number to decimal |
HLOOKUP |
Lookup |
Built-in |
Looks in the top row of an array and returns the value of the indicated cell |
HOUR |
Date |
Built-in |
Converts a serial number to an hour |
IF |
Logical |
Built-in |
Specifies a logical test to perform |
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 |
INFO |
Information |
Built-in |
Returns information about the current operating environment |
INT |
Mathematical |
Built-in |
Rounds a number down to the nearest integer |
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 |
LARGE |
Statistical |
Built-in |
Returns the k-th largest value in a data set |
LCM |
Mathematical |
Analysis ToolPak |
Returns the least common multiple |
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 |
LOOKUP (vector) |
Lookup |
Built-in |
Looks up values in a vector or array |
LOWER |
Text |
Built-in |
Converts text to lowercase |
MATCH |
Lookup |
Built-in |
Looks up values in a reference or array |
MAX |
Statistical |
Built-in |
Returns the maximum value in a list of arguments |
MEDIAN |
Statistical |
Built-in |
Returns the median of the given numbers |
MID |
Text |
Built-in |
Returns a specific number of characters from a text string starting at the position you specify |
MIN |
Statistical |
Built-in |
Returns the minimum value in a list of arguments |
MINUTE |
Date |
Built-in |
Converts a serial number to a minute |
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 |
MODE |
Statistical |
Built-in |
Returns the most common value in a data set |
MONTH |
Date |
Built-in |
Converts a serial number to a month |
MROUND |
Mathematical |
Analysis ToolPak |
Returns a number rounded to the desired multiple |
N |
Information |
Built-in |
Returns a value converted to a number |
NA |
Information |
Built-in |
Returns the error value #N/A |
NETWORKDAYS |
Date |
Analysis ToolPak |
Returns the number of whole workdays between two dates |
NOT |
Logical |
Built-in |
Reverses the logic of its argument |
NOW |
Date |
Built-in |
Returns the serial number of the current date and time |
ODD |
Mathematical |
Built-in |
Rounds a number up to the nearest odd integer |
OR |
Logical |
Built-in |
Returns TRUE if any argument is TRUE |
PERMUT |
Statistical |
Built-in |
Returns the number of permutations for a given number of objects |
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 |
PROPER |
Text |
Built-in |
Capitalises the first letter in each word of a text value |
QUARTILE |
Statistical |
Built-in |
Returns the quartile of a data set |
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 |
RANK |
Statistical |
Built-in |
Returns the rank of a number in a list of numbers |
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 |
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 |
SECOND |
Date |
Built-in |
Converts a serial number to a second |
SIGN |
Mathematical |
Built-in |
Returns the sign of a number |
SLN |
Financial |
Built-in |
Returns the straight-line depreciation of an asset for one period |
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 |
SUBSTITUTE |
Text |
Built-in |
Substitutes new text for old text in a text string |
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 |
SUM_using_names |
Sample |
Sample |
Using SUM(jan) |
SUM_with_OFFSET |
Lookup |
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 |
SYD |
Financial |
Built-in |
Returns the sum-of-years' digits depreciation of an asset for a specified period |
T |
Text |
Built-in |
Converts its arguments to text |
TEXT |
Text |
Built-in |
Formats a number and converts it to text |
TIME |
Date |
Built-in |
Returns the serial number of a particular time |
-Timesheet |
Sample |
Sample |
Sample |
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 |
TRANSPOSE |
Lookup |
Built-in |
Returns the transpose of an array |
TREND |
Statistical |
Built-in |
Returns values along a linear trend |
TRIM |
Text |
Built-in |
Removes spaces from text |
TRUNC |
Mathematical |
Built-in |
Truncates a number to an integer |
TYPE |
Information |
Built-in |
Returns a number indicating the data type of a value |
UPPER |
Text |
Built-in |
Converts text to uppercase |
VALUE |
Text |
Built-in |
Converts a text argument to a number |
VAR |
Statistical |
Built-in |
Estimates variance based on a sample |
VARP |
Statistical |
Built-in |
Calculates variance based on the entire population |
VLOOKUP |
Lookup |
Built-in |
Looks in the first column of an array and moves across the row to return the value of a cell |
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 |