Creating A Basic Excel Formula
by: AndrewWhiteman |
Total views: 3 |
Word Count: 462 |
View PDF | Print View
Share This Article
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 calculates the total of two of the numbers in a spreadsheet (say 3 and 34), we could simply type "=3 + 34". When we press the Enter key, we would see the correct result. However, the formula would have no link to the two cells which contain the numbers. If the data in the cells were to change, the formula would still calculate the old result.
Obviously, what we need to do is to ensure that our formula contains a reference to the two cells in question. The easiest way of doing this is to click on the first cell having typed "=". Excel then automatically creates a reference to that cell. Next type the "+" sign and click on the second cell to pick up its reference. 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.
Now that our formula contains a reference to these two cells, any time the cell contents change, the result returned 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 add up the contents of a hundred different cells. If we relied purely on addition, we would end up creating a formula with a hundred different arguments; in other words, a hundred cell references to each of the cells containing the numbers. Thankfully, we can use the SUM function instead.
To insert a function into a formula, type an equal sign followed by the name of the function. Next, type open parentheses and enter the arguments of the function. The arguments of a function are the parameters required by that function in order to return a result. When using the SUM function, the arguments are the references of the cells contain the numbers we want to total. We can generate these references by clicking or dragging across the cells in question.
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.
Share This Article
Rating: Not yet rated Next Article - The social effects of Web 2.0 and Previous Article - Oracle Consultants Are Well Trained in Peoplesoft Say Staffing Agencies
About the Author
Author is a developer and trainer with Macresource Computer Solutions, a UK IT training company offering Microsoft Excel training courses in London and all over the UK.
Comments
No comments posted.Add Comment
Popular Articles about: Software
1: Viagra2: Adobe Illustrator: Getting Past The Blank Canvas
3: Enhance Your Web Pages With Dreamweaver's Javascript Behaviors
4: How to use a poker software
5: MyCafeCup.com launched new AIO Internet Cafe Software + WiFi HotSpot Gateway Billing.
6: The Easy Way To Write An E-book
7: How to convert swf to Avi, iPod, iPhone, PSP, Zune
8: Optimize Your PC With Registry Cleaner
9: A new version of contextual German-English and English-German dictionary TranslateIt! for Windows
10: Pre-packaged vs. Custom Software
11: Getting Rid Of The This Nasty Philippine Made Virus
12: DOCUMENT SCANNING STORAGE of RECORDS DIGITIZING ARCHIVING PAPERLESS OFFICE NYC.
13: Your Reaction to the Idea of Paying Students
14: Using Personal Computers to Solve Humanitarian Problems
15: The Story of Finding Longitude: It Was All a Question of Timing
16: Choosing the Turnkey Software for your Business
17: Find Home Renovation Software
18: Tokenless Two Factor Authentication Ensures Secure Remote Access
19: The Way People Communicate Has Changed Over Time
20: Windows Vista Ultimate OEM Software
21: How To Safely Clean Windows Registry
22: Commercial Driver’s License CDL Manual
23: Management Software To Drive Your Bottom Line
24: Multiple Streams of Income...Surefire Way to Success
25: How to find an email address easily
26: Does iBuzzPro Automatic Recruiter Software Actually Work?
27: How To Use Article Marketing For Free Unlimited Traffic
28: Big Ticket to Wealth Retail Store-- Is It Worth A Visit?
29: Don't Buy a Myspace Friend Adder: Compare Consumer Ratings First
30: Cleaning Your Windows Registry Effectively