Excel Tips Tutorial: How To Write Formulas In Excel
Excel is a magnificent tool for all kinds of businesses for mathematical calculation required in sales, accounting, technology and so on. Small businesses getting helped a lot by using excel to make numerous types of calculation using just a short formula. In this article, we will show some very basic equations which will be helpful for learners to start with calculation using Excel.
Following table shows a number of cells where some number values are put. Now if you want to sum up all the values: first select the cell where you want to see the sum result. Then press equal (“=”) and write SUM(). Now click and put the cursor between the brackets of SUM function. Here the point is, you need to write down those cell names which you want to sum up between the brackets.
Instead of writing cell names, an easier way is to click the mouse between the brackets and then drag the mouse and select the cells you want to sum.
In Below picture you can see, all cells from D4 to G7 are selected and a blinking border is created surrounding the cells. As you select, it is marked automatically between the brackets of SUM function.
Now just press ENTER. The sum value 1057 is calculated.
Similarly, you can use lot many functions like Product(), Power(), Average(), Max(), Min() etc..
Say, if you want to find the average value of all cells here, just write =Average() and put cells within the brackets in the same way like before and press Enter. You will see the average value 66.0625 is calculated instantly.