"Excel 2007 Formula: An Overview"

This tutorial guides you on Excel 2007 formula and how to enter the formula as well as the formula error messages.

A formula is an equation that performs operations on worksheet data. You can use an Excel 2007 formula to perform mathematical operations, such as addition and multiplication, or they can compare worksheet values, join text, averaging a student's test results, etc.

Formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. In addition, if you change the data in your spreadsheet, Excel will automatically recalculate the answer without you having to re-enter the formula.

A basic formula format will start with an equals sign (=) followed by one or more operands, separated by one or more operators. Operands can be values, text, cell references, ranges, defined names, or function names. Operators are symbols used to represent the various arithmetic and comparison operations you can perform on the operands.

In Microsoft Excel 2007, operators are executed in this order:

To enter a formula

• Place the cursor in the cell where the formula will appear, i.e.E5.
• Enter an = sign. All Excel formulas start with the 'equal' sign.
• Enter the expression that will produce the result you want. This can consist of operands, values, variables, and symbols which represent mathematical procedures such as + or - to add and subtract, e.g. A5+C5.
• When the formula is complete, press Enter. The result of the formula will be calculated and displayed in the cell E5.
• You can see the formula in the Formula bar at the top of the screen by placing the cell pointer on the cell E5.

• If there is an error in a formula, an error message is displayed which will begin with a # sign.

To know the Excel 2007 formula error messages

• When writing formulas it is easy to make a mistake. Here are some common mistakes:

To enter a cell or range reference by pointing

• Place the cursor in the cell where the formula will appear.
• Enter the formula up to the point of the cell or range reference, e.g. to enter the formula =E2+E5, only enter the = sign.
• Using the arrow keys, move the cell pointer to the first cell reference, in this case E2. The formula will track your progress and enter the current address into the formula.
• Enter the operand, + sign.
• Using the arrow keys, move the cell pointer to the second cell reference, in this case E5. If you are calculating a range of cells, hold down the Shift key while using the arrow keys to move to the intended cells.
• Press Enter to complete the formula when you have reached the cell you require.

Related Topics:

This is the introduction to Excel 2007 formula, more tutorials available at the following links:

Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
How to Use the Cell Function in Microsoft Excel 2007?
Guide to Use the NOW Function Correctly in Excel 2007
Demonstration of Using the Date and Time Functions with Excel 2007
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Using the Excel 2007 Count Function - Example Demonstration
Guide to Use the Excel 2007 Radian Function Correctly

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel 2007 formula info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb