Site icon Syrus

Excel: How to Create a simple formula

person holding white Samsung Galaxy Tab

The release of today is another chapter of Excel saga. In this chapter, you will find the background of the topic and a guide about it. As you can read on the title, the topic is creating formula, specially a simple one. 

Keep in mind that Excel formulas are the heart of the program, since they are the ones in charge of doing the “calculation” of the spreadsheet. Excel files can be opened in other apps, remember that, but if you use another one, the way to proceed with the formulas could be different. 

Before going into another chapter of more complicated formulas, today we will see how to do the simplest mathematical operations: addition, subtraction, multiplication and division. Technically, only addition is a formula, since in all other cases special operators are used. 

What is a simple formula? 

A simple formula is used to do addition, subtraction, multiplication, and division in your worksheet in Excel using standard operators and signs for exponents. These formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk (*), or forward slash (/) signs. 

Example: = A2 / C2 

Example: = A1 * A3 * A5 * A8 

Example: = A2 – A3 

Example: =SUM (A1:A50) 

Excel respects the logical order of mathematical operations (multiplication and division first, then addition and subtraction) and supports the use of parentheses to give priority to some operations over others. Thus, you can create formulas such as = (A1 + C2) * C7 / 10 + (D2 – D1). 

Now, it is time to see an example of a simple formula: 

  1.  On the worksheet, click the cell in which you want to enter the formula. 
  2. Type the (=) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. 


3. Depending on your device, press Enter (Windows) or Return (Mac). 

 Use AutoSum 

To make a quick sum, you can use AutoSum. Select a cell next to the numbers you want to sum, click AutoSum (the icon that looks like an M in horizontal) on the Home tab, press Enter (Windows) or Return (Mac). 

When you click AutoSum, Excel automatically enters the formula, that uses the SUM function to sum the numbers

Advice: You can use a quick start, typing ALT+= (Windows) or ALT+COMMAND+= (Mac) into a cell, and Excel automatically inserts the SUM function. 


Exit mobile version