1. Computing & Technology
About.com
Spreadsheets

Formulas and Functions

By , About.com Guide

This series of tips, tutorials, and articles covers how to create and use formulas and functions in Excel and other spreadsheet programs.
  1. Spreadsheet Formulas
  2. IF Functions
  3. Date and Time Functions
  4. Lookup and Reference Functions
  5. Math Functions
  6. Rounding Number Functions
  7. Random Numbers Functions
  8. Logical Functions
  1. Text Functions
  2. Count Functions
  3. Statistical Functions
  4. Information Functions
  5. Trig Functions
  6. Financial Functions
  7. 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.

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.

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.

Lookup and Reference Functions

Excel's Lookup functions can help you find specific information in large data tables such as an inventory list of parts or a large membership contact list. The usefulness of several of these functions can be extended by using them in an array formula.

Math Functions

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

Rounding Number Functions

The tutorials in this section cover the functions in Excel that are used when rounding numbers up or down. Each tutorial includes a step by step example of how to use it for rounding numbers in Excel.

Random Numbers Functions

The tutorials in this section cover the functions in Excel that are used generate random numbers in Excel. Each tutorial includes a step by step example of how to use it to generate random number in Excel.

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 Functions

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

Count 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.

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.

Information Functions

Excel's Information functions gives you information 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.

Trig Functions

Excel's list of functions includes the common Trig functions that can be used to find the sine, cosine, and tangent of an angle.

Financial Functions

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

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.

See more newsletters

©2012 About.com. All rights reserved.

A part of The New York Times Company.