This is the first dedicated post on Excel Formula.
To access formulas click Formulas tab.
Even we can start with formula under Home Tab too.
To access formulas click Formulas tab.
Even we can start with formula under Home Tab too.
 | |
| Under Home Tab |
Excel is always formula ready. One can start dealing with formula at any space.
Things to remember
- Formula always starts with =
- While writing formula ignore upper case or lower case criteria, just start typing.
- Instead of typing the cell values while writing formula one can link or denote the corresponding cell by clicking at the cell. Say, want to multiply F2 to G2, only type = and then click at F2 cell then type * lastly link G2 by clicking at G2 cell. Simple......
Lets start
Sum
How to sum up cells with values?Formula Syntax
=SUM(B3:B14)
(B3 to B14 cells are just imaginary)
Alternatively
=B3+B4+B5+B6.......................so on
Result will be same as before
For instance, we are going to sum up the values of cells F3 to F13
and display the summation at F14.
- Just select the cells F3 to F114.
- Under Home tab click 'Auto Sum'.
Alternatively
- At F14 cell start writing the formula as =sum(
- At this instance just select the F3 to F14 cells altogether.
- Close the bracket.
- Press Enter.
Deduct
Say we are going to deduct the cell value F13 from F14 cell value.Very simple logic.
Write the formula
=F13-F14
Again
We are going to deduct 100 from cell F13 Value.
=F13-100
Multiply
In excel or precisely computer recognize * asterisk as a sign of multiplication.
Say, we want to multiply cell value F13 with G13 and display the result in H13.
At H13 cell write the formula
=F13*G13
Division
Excel as well as Computer recognizes division with the sign '/'.
Say dividing F3 cell with F2 cell.
Syntax is
=F3/F2
Very simple logic.
Auto sum function is always very handy in all instance.
If we observe carefully it combines all function at once.
Observe the ILL 1 below.
 | |
| ILL1 |
Auto Sum function combines all.
No comments:
Post a Comment