Financial

DDB (cost, salvage, life, period, factor)

Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify.

FV (rate, nper, pmt, pv, type)

Returns the future value of an investment.

IRR ( values, guess)

Returns the internal rate of return for a series of cash flows.

NPER (rate, pmt, pv, fv, type)

Returns the number of periods for an investment.

NPV (rate, value1, value2,...)

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

PMT (rate, nper, pv, fv, type)

Returns the periodic payment for an annuity.

PV (rate, nper, pmt, fv, type)

Returns the present value of an investment.

RATE (nper, pmt, pv, fv, type, guess)

Returns the interest rate per period of an annuity.

SLN (cost, salvage, life)

Returns the straight-line depreciation of an asset for one period.

SYD (cost, salvage, life, per)

Returns the sum-of-year's digits depreciation of an asset for a specific period.

Date and Time

DATE (year, month, day)

Returns the serial number of a particular date.

DATEVALUE (date, text)

Converts a date in the form of text to a serial number.

DAY (serial_number)

Converts a serial number to a day of the month.

HOUR (serial_number)

Converts a serial number to an hour.

MINUTE (serial_number)

Converts a serial number to a minute.

MONTH (serial_number)

Converts a serial number to a month.

NOW()

Returns the serial number of the current date and time.

SECOND (serial_number)

Converts a serial number to a second.

TIME (hour, minute, second)

Returns the serial number of a particular time.

TIMEVALUE (time_text)

Converts a time in the form of text to a serial number.

YEAR (serial_number)

Converts a serial number to a year.

Math and Trig

ABS (number)

Returns the absolute value of a number.

ACOS (number)

Returns the arccosine of a number.

ASIN (number)

Returns the arcsine of a number.

ATAN (number)

Returns the arctangent of a number.

ATAN2 (x_num, y_num)

Returns the arctangent from x and y coordinates.

COS (number)

Returns the cosine of an angle.

COUNTIF (range, criteria)

Counts the number of non blank cells within a given range that meet the given criteria.

DEGREES (angle)

Converts radians to degrees.

EXP (number)

Returns e raised to the powwer of a given number.

FACT (number)

Returns the factorial of a number.

INT (number)

Rounds a number down to the nearest integer.

LN (number)

Returns the natural logarithm of a number.

LOG (number, base)

Returns the logarithm of a number to a specified base.

LOG10 (number)

Returns the base 10 logarithm of a number.

MOD (number, divisor)

Returns the remainder from division.

PI()

Returns the value of pi.

POWER (number, power)

Returns the result of a number raised to a power.

PRODUCT (number1, number2,...)

Multiplies its arguments.

RADIANS (angle)

Converts degrees to radians.

RAND()

Returns a random number between 0 and 1.

ROUND (number, num_digits)

Rounds a number to a specified number of digits.

SIN (number)

Returns the sine of the given angle.

SQRT (number)

Returns a positive square root.

SUM (number1, number2,...)

Add its arguments.

SUMIF (range, criteria, sum_range)

Adds the cells specified by a given criteria.

TAN (number)

Returns the tangent of a number.

TRUNC (number, num_digits)

Truncates a number to an integer.

Statistical

AVERAGE (number1, number2,...)

Returns the average of its arguments.

COUNT (value1, value2,...)

Counts how many numbers are in the list of arguments.

COUNTA (value1, value2,...)

Counts how many values are in the list of arguments.

COUNTBLANK (range)

Counts the number of blank cells within a range.

MAX (number1, number2,...)

Returns the maximum value in a list of arguments.

MIN (number1, number2,...)

Returns the minimum value in a list of arguments.

STDEV (number1, number2,...)

Estimates standard deviation based on a sample.

STDEVP (number1, number2,...)

Calculates the standard deviation based on the entire population.

VAR (number1, number2,...)

Estimates variance based on a sample.

VARP (number1, number2,...)

Calculates variance based on the entire population.

Lookup

CHOOSE (index_num, value1, value2,...)

Chooses a value from a list of values.

COLUMNS (array)

Returns the number of columns in a reference.

HLOOKUP (lookup_value, table_array, row_index_num,...)

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

INDEX (reference, row_num, column_num)

Uses an index to choose a value from a reference.

MATCH (lookup_value, lookup_reference, match_type)

Looks up values in a reference.

ROWS (array)

Returns the number of rows in a reference.

VLOOKUP (lookup_value, table_array, col_index_num,...)

Looks in the first column of an array and moves across the row to return the value of a cell.

Database

DAVERAGE (database, field, criteria)

Averages the values in a column in a list or database that match conditions you specify.

DCOUNT (database, field, criteria)

Counts the cells that contain numbers in a column in a list or database that match conditions you specify.

DCOUNTA (database, field, criteria)

Counts the non blank cells in a column in a list or database that match conditions you specify.

DGET (database, field, criteria)

Extracts a single value from a column in a list or database that matches conditions you specify.

DMAX (database, field, criteria)

Returns the largest number in a column in a list or database that matches conditions you specify.

DMIN (database, field, criteria)

Returns the smallest number in a column in a list or database that matches conditions you specify.

DPRODUCT (database, field, criteria)

Multiplies the values in a column in a list or database that match conditions you specify.

DSTDEV (database, field, criteria)

Estimates the standard deviation based on a sample, using the numbers in a column in a list or database that match conditions you specify.

DSTDEVP (database, field, criteria)

Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify.

DSUM (database, field, criteria)

Adds the numbers in a column in a list or database that match conditions you specify.

DVAR (database, field, criteria)

Estimates variance based on a sample, using the numbers in a column in a list or database that match conditions you specify.

DVARP (database, field, criteria)

Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify.

Text

EXACT (text1, text2)

Checks to see if two text values are identical.

FIND (find_text, within_text, start_num)

Finds one text value within another (case-sensitive)

LEFT (text, num_chars)

Returns the leftmost characters from a text value.

LEN (text)

Returns the number of characters in a text string.

LOWER (text)

Converts text to lowercase.

MID (text, start_num, num_chars)

Returns a specific number of characters from a text string.

PROPER (text)

Capitalises the first letter in each word of a text value.

REPLACE (old_text, start_num, num_chars, new_text)

Replaces characters within text.

REPT (text, number_times)

Repeats text a given number of times.

RIGHT (text, num_chars)

Returns the rightmost characters from a text value.

SUBSTITUTE (text, old_text, new_text, instance_num)

Substitutes new text for old text in a text string.

T (value)

Converts its aruments to text.

TRIM (text)

Removes spaces from text.

UPPER (text)

Converts text to uppercase.

VALUE (text)

Converts a text argument to a number.

Logical

AND (logical1, logical2,...)

Returns TRUE if all of its arguments are TRUE.

FALSE()

Returns the logical value FALSE.

IF (logical_test, value_if_true, value_if_false)

Returns one value if logical test evaluates to TRUE, and another value if it evaluates to FALSE.

NOT (logical)

Reverses the logic of its argument.

OR (logical1, logical2,...)

Returns TRUE if any argument is TRUE. Returns FALSE if all arguments are false.

TRUE()

Returns the logical value TRUE.

Informational

ERROR.TYPE (error_val)

Returns a number corresponding to an error type.

ISBLANK (value)

Returns TRUE if the value is blank.

ISERR (value)

Returns TRUE if the value is any error except #N/A.

ISERROR (value)

Returns TRUE if the value is any error value.

ISLOGICAL (value)

Returns TRUE if the value is a logical value.

ISNA (value)

Returns TRUE if the value is the #N/A error value.

ISNONTEXT (value)

Returns TRUE if the value is not text.

ISNUMBER (value)

Returns TRUE if the value is a number.

ISTEXT (value)

Returns TRUE if the value is text.

N (value)

Returns a value converted to a number.

NA()

Returns the error value #N/A.