Creating Formulas in Excel.
For many Microsoft Excel users, Creating Formulas in Excel is the most common thing they do. Formulas many times straight forward simple and easy to use.
- Creating simple formulas.
- Copying a formula into adjacent cells.
- Creating a percentage change formula
- Using AVERAGE formula.
- Using SUM formula.
- Using Auto-Sum.
- To know the maximum number.
- To know the Minimum number.
Creating Formulas in Excel Now start simple formulas.
But they start with a different concept.
Example-1.
Suppose you want to cut 100 from 120 number.
But in Microsoft Excel typically we type formulas based on location I mean row and column.
Example -2.
120 number show location as column B and row shows location as 2.
100 number show location as column B and row shows location as 3.
Also, we can type physically row and column address but we do not need it.
When you use formulas the first requirement is that we have to give equal to sign ( = ).
before starting formula like below example.
Example-3.
In this above example, we have used equal to sign (=) at the beginning.
Then we have used b2 it is cell address of number.
Secondly, we have used minus – sign for subtraction.
Noted: in place of minus sign – we can also use + addition, * multiply, / divide.
Then I have used b3 which is the address of number 2 at the end you can use enter from the keyboard or click mouse another place.
Hit Enter.
Addition.
+
–
*
/
=sum.
Copying a formula into adjacent cells.
See below example where we have used minus formula.
Same thing you want to do with C, D, E, F, and so on other columns.
You can copy to left or downside.
Hold down left mouse and continues to right.
For checking double click.
In copying, we are also copying cell address.
Creating a percentage change formula.
Hit enter.
Using AVERAGE formula.
=Average ().
Using SUM formula in Creating Formulas in Excel.
=sum()
Using AutoSum.
To know the maximum number.
=Max( )
To know the Minimum number.
=Min( )
Introduction to Microsoft Excel.