Basic Calculations in Excel – Addition, Subtraction, Multiplication, Division
As mentioned earlier, you need to make use of the basic operators like +, -, *, / here. All you need to remember is that all the formulas need to start with a (=) sign. In the Excel sheet below, in the first table, you can see two numbers 10 and 5, which is our data. In the other table, you can see the operations to be carried out by applying appropriate formulas.
How to insert Formulas in Excel
Formulas can contain cell references, ranges of cell references, operators, and constants. Let us see how this is done.
Quite simple and easy, right? TIP: This post will help you if Excel Formulas are not updating automatically.
How to insert & use Functions in Excel
Functions help you perform a variety of mathematical operations, lookup values, calculate date and time, and a lot more. Browse through the Function Library in the Formulas tab to learn more. Now let us see a few examples on how to insert and use functions. The table below displays the name of the student and the marks obtained by each one of them.
To calculate the total marks of all the students, we need to use the Sum Function. There are two ways to so.
Select the cell E7, and type =SUM(E2:E6) and then press Enter. The answer will be automatically displayed in cell E7.
Click on the cells you want to select, that is, cell E2 to cell E6. In the Formulas tab, under the Function Library group, click on Auto Sum dropdown menu, and then further click on Sum. The correct value will be displayed in cell E7.
This is how you can calculate the total value from a given set of values by using the Sum Function. Similarly, you can perform various other functions such as Average, Count, Min, Max, and so on, depending on your requirement. I hope you found this basic tutorial useful. Now read: How to calculate the Median in Excel.
