How to create simple formulas in Excel 2013?

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:












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

In Category: Excel 2013, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.