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
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
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.
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.
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
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.
- Excel 2003 Formulas Step by Step Tutorial
- Excel IF Function Step by Step Tutorial
- SUMPRODUCT Function: COUNTIF for Multiple Criteria in Excel 2003
- Excel 2003 AutoSUM
- Excel Autosum Function (video)
- Date Function in Excel
- Excel 2003 AVERAGE Function
- Excel 2003 MAX Function
- Excel 2003 MIN Function