How do I enter formulas in Excel

The formula is the Excel powerful data processing function basic assistant, by using the formula, you can realize the massive data fast computation easily, how Excel enters the formula? The answer is simple, see the example below.

The problem is: Calculate the sum in the A4 cell with the data from the sample table below.

Sample Table	A
1	1203.11
2	1104.56
3	1178.29
4

Note: A is the column number in the table above, and the left 1-4 is the line number.

The method is: click A4 cell (A4 cell is in column A, the cell that crosses the 4th row, which is the position of our colored instance), enter =A1+A2+A3 on the keyboard, and then press the keyboard enter key to complete the formula calculation (result 3485.96)

To enter the Excel formula correctly, you must keep the following points in mind:

1, the formula must begin with =. Whether it's a simple formula or a more advanced function, you need to mark it as a start, otherwise all the formulas are just characters, but not the computing function.

2, accurate use of cells. The data cell name used in the formula to see clearly, a, B, C, D is the column number, 1, 2, 3, 4, 5, 6 is the line number;

3, the correct use of functions. All the functions in the formula are in English parentheses () in pairs, not less left or right, the use of functions can be entered or use the method of inserting the function, but not spelling errors;

4. The formula ends with the keyboard enter key. to = Start, to enter the end of the formula is the most basic requirements, must not be entered after the formula did not press ENTER after the click of the mouse, the formula will be destroyed;

Special note: Although many places are teaching you how to use the mouse to click the method to complete the formula input, but as a beginner advised you not to do so, learn to read and correct input formula will speed up your understanding of the formula and use. It's easy to use a mouse-click method to complete a special formula when you're proficient, but using this method prematurely can make it harder to understand how formulas and formulas are used, because there are too many steps to do so.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join