FV

Calculates the future value of an investment using a constant interest rate and periodic, unvarying payments.

AND

Displays TRUE when all arguments are true.

IF

Displays different values based on whether a condition is true or false.

NOT

Will change FALSE to TRUE or TRUE to FALSE.

OR

Displays TRUE when any argument is true.

SUM

Adds a range of data.

MAX

Identifies the highest number in a range of data.

MIN

Identifies the lowest number in a range of data.

PMT

Use constant payments and a constant interest rate to calculate payments for a loan.

PV

Calculate the present value (NOT the net present value) of an investment.

IFERROR

Displays specified text if an argument contains an error and the value in the argument if the argument does not contain an error.

AVERAGEIF

Averages the cells specified by a given condition or criteria.

COUNTIF

Counts the number of cells specified by a given condition or criteria.

SUMIF

Adds the cells specified by a given condition or criteria.

NPV

Calculate the net present value of an investment based on a discount rate, a series of future payments, and income.

RATE

Displays the interest rate per period of a loan or an investment.

UPPER

Converts text to all uppercase letters.

LOWER

Converts text to all lowercase letters.

CONCATENATE

Joins two or more strings into one text string.

PROPER

Capitalizes the first letter in a string of text as well as any text following a space.