Learn to write excel formula

How to write formula?

To write, a formula first selects a cell where you want your answer. The answer will be displayed in that cell. After selecting the cell writes equal(=), and then write the formula.

For example:
Suppose you want to do the sum of two numbers written in a different cell. To do this first select a cell and give equal sing and then select the first number cell then give plus(+) sing then select the second number cell.
=A1+A2
To select cells just click on that cell. To get the answer press enter.

Suppose you have some values in A1, B1 and A2 cells and you want the sum of A1, B1 cell value and then subtract by A2 cell value:
So we will select a cell for answer and will write like this:
=A1+B1-A2
Or we can write like this,
=(A1+B1)-A2

Now here can be a question,
What is A1, B2, and C2 or how to find A1, A2 or B2 cell in the sheet?
In excel the columns number are represented by letters like A, B, C, D, E, etc and the row numbers are represented by numbers like 1, 2, 3, 10, 122, etc.

First column number is A, second is B, third is C, fourth is D and so on and first row number is 1, second is 2, third is 3 and so on. So A1 means first column(A) first row(1), A2 means first column(A) second row(2). Similarly B2 means second column(B) second row.

Now, look at one thing, when you type in a cell the same thing is also displayed in the green marked area. After selecting the cell you can also write the formula in the green marked area. So we can say that we can write formula in formula bar(green marked area) and also in the selected cell which we selected for display the answer.

In the image, you can see a formula to get the sum of A2 and B2 cells and you got the output 7. Now for other cells, you don't need to write the formula again and again. What you have to do is that after getting the output click on the cell where you have the output. In this case, the output is 7. So click on this cell. After clicking on the cell if you place the cursor to the black square marked position then a plus sign will appear. Click on the plus sign and drag down to the last cell. If you do then the same formula will apply to other cells and you will get the sum for other cells also. For any formula, you can do this thing.