The basic mathematical formulae that you will need in a spreadsheet are as follows:
Formula |
Keystroke |
To add |
+ |
To subtract |
- |
To divide |
/ |
To multiply |
* |
Important: When entering any formula in to a cell, you must always start with a “=” sign
For example, lets say that in cell A4 you wanted to show the result of the numbers in cells
A1 and A2 added together. You would need select cell A4, type in “=A1+A2″ and press enter.
The result will then display as follows:
Note: Cell A4 now displays the result of the calculation.
If you look in the formula bar when you have the cell selected, it will display the formula.
Try changing the numbers in cells A1 and A2, and watch the result of the calculation on A4 change automatically.
This same method is used with each of the other four basic calculations.
Let’s change the formula in A4 to a multiplication instead of an addition. Select the cell, and click your cursor in to the formula bar above the spreadsheet where it currently says “A1+A2″. Replace this with “A1*A2″
and press enter. The result of the sum is now a multiplication.
The equation you choose can be as complicated as you want and can just contain numbers as well as call names: = 15+15. In the case of a more complicated equation excel will work out division and multiplication before and then move on to adding and subtracting. To prevent this you will need to tell it to do the adding or subtracting first. The way you do this is to put the bit you want done first in brackets, i.e. (1+2)/3< ><–>
All of this is covered in our Beginners Excel Course. Once you have mastered these skills you will be ready to attend our Advanced Excel Course, and really advanced might want to try VBA for Excel.
Similar resources you may like
Tags
calculation, Excel, Excel 2007 Tutorial, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, spreadsheet, Spreadsheets, Tips, top Tips, Training
Share This Resource
Leave a Reply
+44 (0)1273 622272
Follow Silicon Beach Training
Categories
Upcoming courses
- 6 - 10 Sep 2010
2272 - Implementing and Supporting Microsoft Windows XP Professional - 6 - 8 Sep 2010
Lean Processes and Tools - 6 - 10 Sep 2010
Software Test Management - 6 - 8 Sep 2010
PRINCE2 Foundation - 6 Sep 2010
Project Management - 6 - 8 Sep 2010
Project Management & MS Project - 6 - 8 Sep 2010
Systems Development Essentials with Agile - 6 - 10 Sep 2010
PRINCE2 Practitioner - 6 - 8 Sep 2010
Systems Modelling Techniques with UML - 7 - 8 Sep 2010
MS Project - 9 - 10 Sep 2010
PRINCE2 Practitioner Conversion - 9 - 10 Sep 2010
2794 - Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 - 9 - 10 Sep 2010
Lean Six Sigma Yellow Belt - 9 - 10 Sep 2010
HTML - 9 - 10 Sep 2010
Modelling Business Processes
|
|
|