How to Set Formula in excel …excel sheet me formula set kaise kare

Dosto, aaj me aapko excel sheet me formula set kaise karte hai wo shikhaunga…kya aap excel me formula set karne ke bare me janete ho??? DOsto Ek bat khat yad rakhni hai ke formula set karne se pahle CELL me (=) sign karni avasyak hai,to chale formula set karne ka step follow karte hai .
 

Addition Formula 
Step 1: Apko jis CELL me Formula set karni ae CELL select karo 
          for Ex. niche jo photo dikhay de raha hai usme muje H2 Cell me formula set karni hai to me H2 Cell ko Select krti hu ,muje gujrati,hindi english,computer subjects ka mark total me chahiye ,Dosto App Dusre photo  me dekh sakte ho ke maine  =d2+e2+f2+g2 Formula Apply kari hai

 method  1:    =d2+e2+f2+g2

 method  2:     =sum(d2,e2,f2,g2)

Step 2:                                                                                                                                               
Dosto,Apko Sabhi row me formula lagani hai to jis CELL me formula lagayi hai us CELL pe click karke mouse Pointer niche taraf kecho aapko Automatic Sabhi CELL me formula lag jayegi ……….

(adsbygoogle = window.adsbygoogle || []).push({});

Subtraction Formula                                                                                                                                 

Step 1: Apko jis CELL me Formula set karni ae CELL select karo 

 
        for Ex. niche jo photo dikhay de raha hai usme muje I2 Cell me
formula set karni hai to me I2 Cell ko Select krti hu ,muje Total Marks me se Total bad(Subtract ) krna hai ,Dosto
Aap Dekh sakte ho ke maine =c2-h2 formula lagayi      
Method 1:  =c2-h2
                                                                                                              

 
Multiplication Formula    
Step 1:Apko jis CELL me Formula set karni ae CELL select karo 
 
        for Ex. niche jo photo dikhay de raha hai usme muje D15 Cell me
formula set karni hai to me D15 Cell ko Select krti hu ,muje 38*263 Multiplication karna hai ,Dosto
Aap Dekh sakte ho ke maine =b15*c15 formula lagayi      
Method 1:  =b15*c15
                                                                                                                         

This Mathematical Operator . . .. . .             Is Used For

(adsbygoogle = window.adsbygoogle || []).push({});

+ (plus sign)                            Addition
– (minus sign or hyphen)                            Subtraction
* (asterisk)                            Multiplication
/ (slash)                            Division
^ (caret)                            Raising a number to an exponential power

Post Author: dworld

Leave a Reply

Your email address will not be published. Required fields are marked *