Hi friends you should know the basic excel formulas when you are newbie.
Following some formulas I learned when I used excel first time.
Sum:
This formula is use to get sum of selected range.
one most important thing you should know is every formula is begin with "="
If you have 1,2 & 3 these numbers in A1, A2 & A3 respective cells you want sum in A5 cell as given in above figure.
then just enter "=SUM(A1:A3)" in cell A5 and you will get result 6 the sum value .
This is a example of simple excel formula if you want to learn more advance and important formula refer below link:
how to use vlookup formula in excel
This is a example of simple excel formula if you want to learn more advance and important formula refer below link:
how to use vlookup formula in excel
No comments:
Post a Comment