dworld dworld Author
Title: How to Set Formula in excel ...excel sheet me formula set kaise kare
Author: dworld
Rating 5 of 5 Des:
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??? D...
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 ..........
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


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


About Author

Advertisement

Post a Comment

LED lights, Penal light, street light, Flood light etc.

 
Top