All Mathematical Formulas used in [MS Excel] with examples and practical

 HOME PAGE 

1. Addition Formula use in [ MS Excel ] :-

                                    In the Normal condition when the two given no add like ( 3+6)=9 . But the ms excel is a application software . He provides the sheet (like a black copy) . A sheet provides a lot of ms excel cells.  

Let's go to a example and solved the problem in ms excel sheet. 

Example 1. Write a formula to add the given no 34,54,76,24,80 if cell is anything.

Solution:-

                 Let A1 cell = 34

                        A2 cell = 54

                        A3 cell = 76

                        A4 cell = 24

                        A5 cell = 80

Formula    [ =A1+A2+A3+A4+A5 ] 

Look the practical sheet and Solution:-

Result :-

Example 2. Write the Additional Formula if cell value is given A2=56, B6=40, D5=76 Write the result in cell B8 ?

Solution:-

                 Formula   [ =A2+B6+D5 ]

Look the practical sheet, who to apply Formula and Additional Formula result :-

Additional Formula result:-

Example 3. Write a formula who add all the value of columns A and B and show the result in D3 cell. 

Solution:-

         Formula  is [ =sum(A:A+B:B) ]

This Formula is working only Google works sheet

   MS Excel Formula  [ =sum(sum(A1:A8)+sum(B1:B8))]

Look at the Additional example practical sheet:-

Result of Formula:-

Example 4. Write a formula who add the given cell value.  A1,A2,A3,A4,A5,A6,A7,A8,A9 and B1,B2,B3,B4,B5,B6,B7,B8,B9 and write the result in cell B11.

Solution:- 

 Formula of this Addition  [ =sum(sum(A1:A9)+sum(B1:B))]

Practical sheet of above Formula:-

Result practical sheet:-

Note :- Substation and  multiplication  process is same as the Additional Formula.  If change the Additional symbol (+) your Formula is charged according you.

Example:-

1.  Substation Formula 

a)   =A1-A2

Look practical sheet:-

Result:-

b)   =D5-E4

Practical sheet of above Formula:-

Result of Formula sheet:-

Note:- standard Formula of Additional example 3 and 4 is not applicable for the substantial and multiplication function. 

2. Multiplication Formula 

a)  = A1×A2×A3×A4

Project sheet of above Formula:-

Note :- If you drop any cell value the result is 0 find because cell default value is equal to 0.

Result:-

b)  =C3×B4×K8

Project sheet of above Formula 

Results of this example:-

Example 5. Write a formula who calculated the simple interest,  if all the value is given.

Solution:- 

                we khon that SI = (P×t×r)/100

Where P = Principle Amount 

             t = Time

             r = ratio 

Let C1 =P

       C2 = t

       C3 = r

Then

MS Excel Formula for this problem 

              =((C1×C2×C3)/100)

Look the practical sheet of above Formula:-

Result of above sheet Formula:-

My practical vedio:-

Other Page

   1. 10 Important Formula applies in [ MS Excel] Sheet

  2. Important Excel Project using VBA Codding

  3. IAS / PCS Best Book And PDF Note

  4 . (4 )Important Excel Codding tips 

  5. Compound Interest calculator Formula for MS Excel