How to Apply Formula in MS Excel? : Whether it is to calculate tables or arrange a lot of data in Excel, applying formulas takes a lot of time and things become more difficult if you do not remember the formula while working in Excel. People who do not know how to apply formula in Excel?
It is often very difficult for those people to do this work, so in this article we will tell you how to apply formulas in Excel.
How to Apply Formula in MS Excel
How to apply formula? Before telling this, let us tell you that while working in Excel, people have to use all kinds of formulas like Add, Minus, Divide, Multiply. We have told you the easiest way to apply this Formula in Excel in a very simple way.
How to Apply SUM Formula in Excel
How to Apply Formula in MS Excel? If you want to add data in Excel, then you can add numbers one after the other like Arithmetic Calculation – A1+B1+C1 or A1+A2+A3.
But using this method will take you a lot of time because you can add one or two digits like this but it is very difficult to add many digits like this.
And this is where the Sum function formula works, this formula is such that you do not even need to enter the complete formula to use it. All you have to do is open the bracket by typing =Sum ( in an empty cell and select the cell you want to add.
=SUM(A1:F1
Your result will come as soon as you enter.
Apart from this, you can also see the formula of add from Auto sum or Sum status bar.
In Autosum, all you have to do is select the cell and click on the Autosum button shown above.
When you select a cell, you are then automatically shown the sum of the cell’s numbers about the status below.
But with both of these methods you cannot sum a lot of numbers. That’s why now whenever you want to add many numbers, then use the sum function.
How to Apply the Minus Formula in Excel
How to Apply Formula in MS Excel? There is no exact function formula to do minus in Excel . That’s why you have to manually enter the minus formula in Excel. To do minus in excel, you have to put =A1-B1-C1- D1 popularly like this, you can directly type A1, B1.
Or you can select if you want. After applying the formula, as soon as you click enter, you will get your result.
Formula to Find Product in Excel
In Excel, if you want to multiply two numbers and find their product. So you have to extract the formula by manually typing it because there is no direct way to extract the product in excel.
To extract the product in Excel, you first have to type = in the empty cell and after that you have to select the number of the first row or column, then give the sign of × multiplicity and select the number of the second row or column.
Divide Formula in Excel
How to Apply Formula in MS Excel? To divide in excel also you have to apply the formula yourself because there is no direct formula or shortcut formula in excel to divide numbers.
To divide in excel, you have to first type = in the cell and select the cell which you want to divide and then you have to enter / divide sign and then select Numerator. Like you can see in the screenshot!
=A1/B1.
How to Calculate Average Formula _
How to Apply Formula in MS Excel? If you want to calculate the average in excel, then there you will not need to type 10+34+67+85+98/5 because doing so is very hard work and waste of time, so here you can find the formula of Average Average. Will have to put
To apply the formula, you first type =Average in a cell and then open the bracket and select all the numbers for which you want to calculate the average.
After selecting the number, as soon as you click on the enter button, your result will appear in front of you. As you can see in the screenshot you have to apply the formula in the same way!
In this way you can apply any formula in Excel very easily! And if you do not want to apply the formula manually, then you can use the shortcut.
Conclusion
So friends, after reading this post, How to Apply Formula in MS Excel?? You must have known this, if you liked this post, then do share it too!
Related Posts: