microsoft Excel Formula

     column    :-     A    B    C    D    E    F    G    H    I     J     K     L    ....    ...    ....    ...    ...    .....

    Row        :-    1    2    3    4    5    6    7    8    9    10    11    12    ....        ....    ....    ....    ...    ....

     Excel में कोई भी फार्मूला ( Formula )  लिखने से पहले बराबर (Equal sing = ) का निशान जरूर से         लिखना  है | 

👉 = Sum (Initial Cell Address : Last Cell Address )  this Formula is used to sum the numeric Value.

            E.g     =sum(f3 : f10)    Press Enter Key form the Key board.

we can also select the range of row or column and click on Auto Sum  ∑  it calculate automatic the total value of the your selected data . Remember auto sum or sum formula only for numeric value.

👉     = f3- f4        For Subtract  (- Minus Sing)

 👉     = f3 * f4        For Multiply  ( * Strict Sing) 

👉     = f3    / f4        For Division  ( / Slash sing)

👉     =Total Marks * percentage value with Sing     e.g     =500*10%     for Percentage

👉     = Now() Press Enter     It show the Date and Time in the Selected  Cell

👉     = Today() Press Enter   It show the only  Date in the Selected Cell which is show in the                      computer

 👉     = if ( a1>=300,"1st", if(a2>=225,"2nd",if(a2>=150,"3rd",if(a2<150,"Fail"))))   

• This formula is used for calculate the division of Mark-sheet where as total marks is equal to  500
• This Format of formula is a Master format of Logical and conditional Problems.
• In this Formula we used the Logical Operator with multiple condition

👉     = Min (Int ital Cell address : Last Cell Address)  to Find the Minimum value

                              e.g  =Min (a1:a10)  Press Enter 

👉     = Max (Int ital Cell address : Last Cell Address)  to Find the Maximum  value

                          e.g  =Max (a1:a10)  Press Enter 

👉     = Average (Int ital Cell address : Last Cell Address)  to Find the Average value 

                         e.g  =average (a1:a10)  Press Enter

👉     = Count(Int ital Cell address : Last Cell Address)  to Find the umber of entries in a number                             field that is in a range or array of numbers.

                                e.g  = count(a1:a10) 

👉     = Count if(where do you want to look?, what do you want to look for ?)  to count the number                 of times a particular city appears in a customer list.

             e.g  =countif(a1:a10,"Phulwari") it show the no of phulwari city in  how many times repeated . 

👉     = SUMIF   Function to sum the values in a range that meet criteria that you specify.

             e.g  :- sumif (a1:a10,"Moday",c1:10)  press enter

                =sum if (range,"Criteria" range")

     👉    =use of AND, OR function in Excel  To See the Image 1

             e.g  :- ==IF(AND(C4>=50000,D4>=50000,E4>=5000),F4*2%,"Hardwork")

            e.g :- =IF(OR(C4>=50000,D4>=50000,E4>=5000),F4*2%,"Hardwork")