Creating A Basic Excel Formula
In order to create an Excel formula, begin by typing an equal sign: this distinguishes it from other types of data. A formula consists of groups of expressions. There are three key elements in these expressions: arithmetic operators, such as add and subtract; functions; and references to worksheet.
To create a formula which returns the total of two of the numbers in a spreadsheet (say 24 and 12), you simply type “=24 12″. When you press the Enter key, you would get the correct result. However, the formula would not be linked to the two cells containing the numbers. If the entry in either of the cells were to change, the formula would still give the old result.
Obviously, the best solution is to ensure that our formula contains a reference to the two cells in question. The simplest method of doing this is to click on the first cell having typed the equal sign. Excel then automatically creates a reference to the cell. Next type a plus sign and click the second cell. Excel puts in a reference to the second cell and we then enter the formula either by clicking on the Enter button (on the left of the formula bar) or pressing Enter on the keyboard.
Once your formula contains a reference to these two cells, any time the contents of the cells change, the result produced by formula will be updated.
If this was the only way of performing calculations in Excel, formulas would very quickly become extremely long and very complex. To avoid this, we can use Excel’s built-in functions. Functions perform complex mathematical calculations without us having to worry about how the result is arrived at.
For example, imagine that we wanted to total the contents of a hundred different cells. If we relied purely on the “+” sign, we would end up creating a formula with a hundred different arguments; in other words, a reference to each of the cells containing the numbers. Instead, we can use the SUM function.
To include a function in a formula, type the equal sign followed by the name of the function. Next, type open brackets followed by the arguments of the function. The term arguments refers to the values required by a function in order to return a result. In the case of the SUM function, all we need to specify are the cell addresses of the numbers we want to total. We can do this automatically by clicking or dragging across each of the cells or ranges that contain those numbers.
When you have entered a reference to all cells containing numbers that we want to total, you can confirm entry of the formula by pressing the Enter key. You don’t even need to close the brackets. Excel will close them for you.
Last 5 posts by Andrew Whiteman
- Using The Office Button And Quick Access Toolbar In Microsoft Excel - October 14th, 2008
- Will QuarkXpress Survive The Adobe Onslaught - October 12th, 2008
- How To Avoid Frustration When Learning Adobe Illustrator - October 10th, 2008
- Excel 2007 What Would We Do Without Functions - October 1st, 2008
- Getting started with Adobe Illustrator - September 19th, 2008
Related posts
- Excel 2007 What Would We Do Without Functions
- Excel VBA Courses Wean Users Off The Macro Recorder
- Using The Office Button And Quick Access Toolbar In Microsoft Excel
- Tips For End Users of Excel 2003 and 2007
- Some Basic Concepts of Fiber Optic Loss Testing
Like this post? Publish It On Your Own Blog
