Formula List

Age Calculation	Sample	Sample	Using DATEDIF()
AutoSum shortcut key	Sample	Sample	Using Alt and =
Brackets in formula	Sample	Sample	Sample
FileName formula	Sample	Sample	Using MID() CELL() and FIND()
Instant Charts	Sample	Sample	Using F11
Ordering Stock	Sample	Sample	Stock Ordering
Percentages	Sample	Sample	How to calculate various percentages
Project Dates	Sample	Sample	Example using date calculation.
Show all formula	Sample	Sample	Using Ctrl and `
Split ForenameSurname	Sample	Sample	Using LEFT() RIGHT() FIND() SUBSTITUTE()
Time Calculation	Sample	Sample	How to calculate time.
TimeSheet For Flexi	Sample	Sample	Example flexi time sheet.
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