How to perform Basic Mathematic Formulas or Calculation in Microsoft Excel 2007 (Using Formulas and Functions)
by: Revengsky Joseph D. Reyes (a.k.a rjdreyes – jcyberinux.com)
Open Microsoft Excel 2007 Spreadsheet.
In able to perform basic operation, each cell has corresponding value. Let say from this example, at cell A2 has a value 0.5 then A3 has a value 4.
In order to make an output automatically, when you input a value, we must have a formula. At cell A4, we have a basic operation formula Addition =A2+A3.
Were equal sign is the equivalent value of A2 + A3. Equals = 4.5
Addition A2 + A3
Subtraction A2 – A3
Multiplication A2 * A3
Division A2 / A3
An output of the operation can be anywhere in the cell, as from the example in Division, I put the output at cell F5.
You can have the SUM of all numbers instantly, by using the function Autosum.
Highlight all the cell blocks, let’s say from D2 to D4, then up to D5(at D5 is the output or the sum of all the numbers).
Then click Autosum. There you go, SUM of all numbers. =SUM(D2:D5)
On Multiplication, =PRODUCT(D2:D5).
Basic question: What if I want to do it in Subtraction or Division.
Answer: Unfortunately, there is no solution for that as the moment, you have to do it manually. (Contrary to the autosum) XD
In Division, I do believe there is a function on specific purpose. Let’s say we need to evaluate the average of numbers, you don’t need to used division, there is a simple task which is average function on formulas.
I hope this tutorials helps you out! 😀