If you have Excel 2000. Excel 2002 or Excel 2003, you can make sure that your formulas are copied to new rows or columns if you put in new data. Find out how you can autofill formulas

If you're not sure what you're looking for, this is the place to start your journey into Excel's functions and formulas.

Suggested Reading

Learning How To Use Spreadsheet IF and IS Functions
Its not easy to know which spreadsheet function you're after sometimes. This quick guide is designed to help you work out what you need to use.

What Is An IF Function?
Ever wondered how to use the IF functions in Excel? This article explains how to use IS and IF functions.

CountIf Function
CountIf is a conditional function that can be used to count cells based on any condition you specify. Find out how you can use it in your spreadsheets.

Excel's IF Function
The IF function can be an incredible tool for your workbooks. Find out how they work.

Nested IF Functions
Nested IF functions are a simple way of doing complex conditional formulas.

Suggested Reading

What Is An IS Function?
Ever wondered how to use the IS functions in Excel? This article explains how to use IS and IF functions.

IsError Function
The IsError function is one of the most useful features of Excel. Find out how you can use this function to get rid of Excel's ugly error messages.