Formulas in Excel can simply calculation tasks and also reduce redundant tasks. Excel 2013 provides your several simple and complex formulas that are useful in general accounting tasks or mathematical calculations. Some of the commonly used Excel formulas are Addition, Subtraction, Multiplication and Division. In Excel spreadsheet, the cell value is represented by cell address also known as cell reference. The basic rule for excel formula is every formula starts with “=” equal sign.
Formulas by Cell Reference:
Table displaying mathematical operators used for calculations:
Add |
+ |
=A2+B2 |
Subtract |
– |
=A2-B2 |
Multiply |
* |
=A2*B2 |
Divide |
/ |
=A2/B2 |
Note: you can also use SUM () for addition in Excel. The function parentheses contains the range of cells. For example- SUM (A2:F2) where A2 or F2 can be a cell reference for a cell range in Row or Column in spreadsheet.
Specifying range of cells in formulas:
Go to the cell where you want the result of calculation
Enter “=” equal sign followed by the starting cell reference
Enter the desired mathematical operator
Enter all reference cells in the formula.
In excel, the answer/result of calculation changes if any value in the reference cell changes. Let’s learn how to modify the formula in Excel 2013.
Modifying formulas in Excel 2013:
You should always modify formulas in excel spreadsheet in Formula Bar.
Use of parentheses in Excel formulas:
Excel follows a definite way of calculating numbers in a specific order in any given equation. Multiplication and division are given preference over addition and subtraction. You can change this order of calculation by using parentheses.
Note: Excel only permits use of “()” for parentheses. Use of “[]”, or “{}” will result in an error
For example:
Without parentheses = 2+5*6= 32 (Order in which calculation is performed – 5 X 6 = 30 -> 30+2- > 32
With parentheses = (2+5)*6 =42 (Order in which calculation is performed – 2+5 = 7 -> 7 X 6 -> 42