How to enter formulas in Excel

The following article details you how to enter formulas and some basic functions in Excel 2013.

For the sake of convenience in the future, you should carefully study the following:

1. How to enter formulas starting with an equal sign.

To enter a formula in Excel, you must start with the equal sign or Excel will interpret it as a string. To enter the formula do the following:

Step 1: Type the equal sign at the position of the cell to calculate according to the formula.

Step 2: Enter the formula you want to calculate for that value cell.

Step 3: Press Enter to see results.

If you want to review the formula of that cell -> click on the cell position, the formula will show on the formula bar.

Example of calculating the total monthly revenue of the following enterprise:

- In the cell to calculate, enter the formula: = D6 + D7 + D8 + D9 + D10

How to enter formulas in Excel Picture 1

- Press Enter -> the result is returned:

How to enter formulas in Excel Picture 2

2. Learn about the formula of total values ​​in a column.

With a formula that contains many terms if you simply use the plus sign -> it will take a lot of time and the results are incorrect -> you can use the formula function to calculate the total value in 1 column that Excel has supported. .

Step 1: Place the cursor at the position you want to sum -> Go to the Home tab -> Editing -> AutoSum -> Sum:

How to enter formulas in Excel Picture 3

Step 2: Press Enter -> there is a formula in cell D11

How to enter formulas in Excel Picture 4

Step 3: Press Enter -> the result is:

How to enter formulas in Excel Picture 5

3. Should copy a recipe instead of creating a new formula.

- In all special cases with a long complex formula, copying the formula is the best solution than creating a new formula. To copy the formula, follow these steps:

Step 1: Click the mouse on the cell containing the formula to copy -> move the mouse to the lower right corner of the cell until the mouse pointer changes to a dark dark cross:

How to enter formulas in Excel Picture 6

Step 2: Hold down the left mouse button and drag the mouse to the bottom cell to be copied -> get the formula when the button appears Auto Fill Option button  How to enter formulas in Excel Picture 7

How to enter formulas in Excel Picture 8

Step 3: Revise the formula to suit the requirements.

- Where the cell containing the formula is not adjacent to the cell to copy the formula, you can use the key combination Ctrl + C and when pasting need to select a valid Paste style to maintain the old formula of the copied cell.

4. Learn about cells (cells) in Excel 2013.

In Excel to determine a cell based on the row index and the column index, in which the row index is numbered, alphabetically. Delivery of rows and columns is a cell, also known as a cell. Refer to description of cell:

How to enter formulas in Excel Picture 9

5. Update the results of the formula.

If you use a formula to calculate a series of data in cells, when there is a change in the value in cells -> the value in the formula automatically updates the changed value.

For example, the first 5 months of sales with the following data:

How to enter formulas in Excel Picture 10

- In February, due to defective products returned by customers, the revenue decreased to 456700 -> revised February sales:

How to enter formulas in Excel Picture 11

- Press Enter -> total sales in 5 months automatically updated according to the change of February revenue:

How to enter formulas in Excel Picture 12

6. Use the Sum formula for several values ​​in the column.

In case the values ​​to be calculated are not contiguous -> you can use the following method and still use the Sum function:

For example, calculate the total turnover of the odd month:

Step 1: In the cell to calculate enter the formula: = SUM (D6, D8, D10). Note that each cell value in the column needs to be summed as a parameter of the Sum function and separated by commas:

How to enter formulas in Excel Picture 13

Step 2: Press Enter -> the result is:

How to enter formulas in Excel Picture 14

7. Use other simple formulas in Excel 2013.

7.1 Calculate the average value.

Excel 2013 supports some simple calculation functions right in the toolbar. For example, let's quickly calculate the average turnover value of 5 months as follows:

Step 1: Click the mouse at the position you want to calculate the average value -> go to the Home tab -> Editing -> AutoSum -> Average.

How to enter formulas in Excel Picture 15

Step 2: After selecting Average the result is:

How to enter formulas in Excel Picture 16

Step 3: Press Enter -> Average 5-month turnover is:

How to enter formulas in Excel Picture 17

7.2 Find the maximum or minimum value.

- Similar to finding average value, maximum value or minimum value is the same. For example, find the biggest revenue in 5 months:

Step 1: Click the mouse at the position you want to calculate the maximum value -> go to the Home tab -> Editing -> AutoSum -> Max.

How to enter formulas in Excel Picture 18

Step 2: Press Enter -> The biggest revenue in 5 months is:

How to enter formulas in Excel Picture 19

In the case of finding the smallest revenue, do the same instead of selecting Max to Min.

8. Print formulas for easy memorization.

If you need to memorize difficult formulas you can print them out so you can memorize them as quickly as possible. To do that you do the following:

- Condition: Your workbook must contain those formulas to be able to print.

- Conduct: Go to FORMULAS -> Formula Auditing -> Show Formulas.

How to enter formulas in Excel Picture 20

After clicking Show Formulas, all formulas in the workbook are displayed, you can print them normally:

How to enter formulas in Excel Picture 21

9. Strange sign on the spreadsheet.

These are common mistakes and frequently encountered, please pay attention:

How to enter formulas in Excel Picture 22

10. Learn other formulas.

- Excel supports many useful formulas for calculations. For more formulas, do the following: Go to Home -> Editing -> AutoSum -> More Function.

How to enter formulas in Excel Picture 23

- A dialog box appears that you learn about other formulas in the Select Function section.

How to enter formulas in Excel Picture 24

Above are instructions on how to enter formulas and some simple formulas that are frequently used in Excel 2013.

Good luck!