# Formulas and Functions

By Ted French

- Spreadsheet Formulas
- IF Functions
- Date and Time Functions
- Lookup Functions and Formulas
- Math and Trig Functions
- Random and Rounding Number Functions

- Logical Functions
- Text and Information Functions
- Count and Database Functions
- Statistical Functions
- Financial Functions
- Excel 2003 Functions and Formulas

## Spreadsheet Formulas

The tutorials listed here include how to create formulas to carry out basic mathematical calculations as well as how to create more complex formulas - such as nesting functions and array formulas. Tutorials include step by step examples.

- Excel Formulas Overview
- Excel Math: How to Add, Subtract, Divide, and Multiply
- Excel Mathematical Operators / Order of Operations
- Using Named Ranges in Formulas

- Show Formulas in Excel
- Basic Formulas and Functions Tutorial
- Excel Array Formula Tutorials
- Nested Functions in Excel

## IF Functions

The IF function test to see whether a given condition is true or false. Depending upon the result, different outcomes for the function can be specified.

The IF function has also been combined with other popular Excel functions to create such functions as SUMIF, COUNTIF, and AVERAGEIF.

- IF Function Step by Step Tutorial
- Nested IF Functions Step by Step Tutorial
- SUMIF Function Tutorial
- COUNTIF Function Tutorial

## Date and Time Functions

Dates are very important in spreadsheet programs like Excel. Most spreadsheets make use of dates in some way. Listed below are a number of date-related tutorials. Each tutorial includes a step by step example of working with dates in Excel.

- Functions that Count Days Between Two Dates in Excel
- Excel Date Functions - Adding the Date to a Spreadsheet

## Lookup Functions and Formulas

Excel's VLOOKUP function can help you find specific information in large data tables such as an inventory list of parts or a large membership contact list.

In addition to VLOOKUP, there are several other - but lesser known - functions that can be used to create specific lookup formulas.

## Math and Trig Functions

The math functions carry out basic math operations such as adding, multiplying, and dividing numbers.

The Trig functions can be used to find the sine, cosine, and tangent of an angle as well as converting angle sizes between radians and degrees.

## Random and Rounding Number Functions

The random number tutorials cover the functions that are used generate random numbers in Excel.

The rounding number tutorials cover the functions in Excel that are used when rounding numbers up or down.

## Logical Functions

These functions return only a true or false answer. They can be used individually or combined with one or more other functions, such as the IF function as seen in the Rolling Dice tutorial.

## Text and Information Functions

Excel's Text Functions help you manage the text data in your spreadsheets.

The Information functions tell about the data in a cell or range of cells. This information includes whether the data is a number, the formatting applied to the cell, or even if the cell is empty.

- Excel CONCATENATE Function
- Excel LEFT Function
- Excel RIGHT Function
- Excel MID Function
- Excel TRIM Function

- Excel UPPER Function
- Excel LOWER Function
- Excel REPLACE Function
- Excel VALUE Function
- Excel Information Function Tutorials

## Count and Database Functions

Excel has a number of Count functions that will total the number of cells in a selected range that meet certain criteria. Since each Count function does a slightly different job the criteria required varies with the function chosen.

Excel's database functions can be used to find specific information based on one or more criteria that you set.

## Statistical Functions

Excel's Statistical functions can be used to analyze data in a variety of different ways. Functions included in the program can be used to find common statistical operations such as finding the average value or ranking data by its largest and smallest values as well as more complex operations such as standard deviation.

- Tutorials that Find the Aveage in Excel
- Excel's MAX and MIN Functions
- Ranking Numbers in Excel
- Excel 2007 Standard Deviation (STDEV) Function

## Financial Functions

Excel's Financial Functions can be used to help you determine changes in dollar value of investments and loans.

- Calculating Loan Payments Using Excel's PMT Function
- Calculating Future Value Using Excel's PMT Function

## Excel 2003 Functions and Formulas

Here you will find step by step tutorials, tips and shortcuts on how to use the common and less common functions available in Excel 2003.