Excel provides us to calculate the different functions by
use operator we can add cells subtract cells multiply cells and divide cells values.
In this post we divide and multiply cells
In the
figure below shows the annual report of the student 
In the
D2 cell we calculate the percentage of the students by putting the formula B2
is the obtain marks and C2 is the Total marks so we use cell reference to
calculate the percentage. Excel compiler detect the equal (=) sign to perform
the calculation. And multiply by constant 100 value to calculate the percentage.
After putting the formula in the cell D2 and then press enter button to get persentage
in the D2 cell as next figure below
Click on the spot which is shows by aero and drag down to
the last entry all selected cell filled by correspondally percentages
after drag
In this post we learnt about how to multiply and divide the cells to calculate the percentage
No comments:
Post a Comment