how to use formula inthe MS excel 2

Now in this post we learnt about how to add cells and subtract cells. lets move on the excel sheet and fill the meaning full data to understand the usage of the addition and subtraction

B2 is the monthly salary and C2 is the tax which is deductive from salary So we put the formula in the cell D2 =B2-C2. After press the Enter button D2 shows the value which is calculated by subtract formula as next picture shown

   click on sopt and drag down as per requirement to calculate total salery.

now we are going to calculate the total monthly salery by sum formula is located cell B13 =sum(B2:B12)

after calculating the total of monthly salery we click on the sopt and drag right two cells

now we have calculate total TAX and Total of total salery by sum formula

In this Post we learnt about sum and subtraction in the MS excel