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)
This Mathematical Operator . . .. . . Is Used For
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)
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 |
Post a Comment