In Excel how to use the calculation formula to calculate?

When Excel establishes a financial report, it is usually necessary to calculate the relevant data, which is where we use the Excel program to facilitate the language. In the calculation of data, you need to establish a formula to achieve, and in the use of the formula, you need to refer to the value of the cell to calculate, then in Excel how to use the calculation formula for the operation? The following small set for everyone to introduce exce simple formula, application Formula method Introduction, to see!

Method/Step

1, here first simple to add yourself to the cell. Enter the = number directly in the empty cell, which means to tell Excel that I want to enter the formula instead of the general input. The subtraction of numbers can be directly carried out. Here we can see the formula

2, the number of cells added, here is the cell content added, we see how to set. Subtraction is the same truth.

3, here needs to be explained, here is also to be in Yo a blank cell to put the operation of the completed value. After the = number, hold down CTRL and click the Addends and addends you want to select, and then press ENTER to complete the operation

4, copy the formula: After completing an addition operation, we choose the operation of the completion of the number, with the mouse to move to the lower right corner until the shape of a plus sign, has been pulled down

5, we first introduce the basic operational symbols: The following sequence is subtraction

6, the operation of a variety of operators, this does not need our tube, inside the program has been designed, we need to use the same as the calculator

7, when we do not remember the formula can be selected at that time using the formula to calculate the value, we can see in the upper formula area

8, here's the formula calculation you can be a row can also be in the vertical column can also be up or down, you can also select a four square

The above is in Excel how to use the calculation formula to carry on the operation method Introduction, everybody learned? method is very simple, the need for friends can follow the tutorial to learn Oh!