Ms Excel Ke
Formulas
Dosto Excel Me 1000ro Formulas Ban Sakte He Bas Formula Hame Banana Ana
Chahiye Chaliye Me Shuru Karta Hu Formula Ke Jankari Dena
Kisi Data Ka Total Karne Ke Lye Sum Ka Formula Kese Lagaye
= Sum( A1: A10) Puri Range Ka Total Kar Dega
Yadi Ap = Sum(A1,A6,A9) Select Karenge To Inhi Ke Range Ka Total
Karega
= A2+ A3 Karenge To Bhi Jod Sakte He
Kuch Normal Formulas
= A2 - A3 Karke Hum Ghata Sakte H
= A3 * A4 Karke Hum Multiply Kar Sakte
He
= A3 / A3 Karke Hum Bhag De Sakte He
Dosto Ye Ho Gaye Sabse Easy Formula Me Step Wise Sare Formulas Ki Jankari Dunga
Yadi Data Me Sabse Jada Bade Number Ka Pata Lagana Hai To
= Max(Range)
Aur Sabse Kam K Lye
= Min(Range)
Aur Ap Ye Janna Chahte Hai Ki Total Character Kitne He To
=Len(Range)
Aur Total Count Karna H Number Ko To
=Count(Range)
Aur Yadi Number Aur Text Dono Count Karna He To
= Counta(Range)
Aur Yadi Total Blank Count Karna He To
=Countblank(Range)
Yadi Apko Koi Bhi Word Repet Karana H Jitni Bar Bhi Tab
= Rept( Word, No Of Time Rept)
Aur Uske Bad
Average Nikalna He To
= Average(Select Range)
Aur Yadi Koi Particular Word/ Number Count Karana H Tab
= Countif( Range,Word Name)
Kisi Bhi Particular Word Se Right Se Kuch Word Uthana H To
= Right(No Of Word)
= Left(No Of Word)
= Mid(No Of Word)
Yadi Kisi Particular Text Me Space Jada H To Use Normal Karne K Lye
= Trim( Range) Karte H Normal Ho Jata He
Text Ko Capital ,Lower,Proper
=Upper(Range)
= Upper( Range)
= Proper( Range)
SIR AP JESE KE BAJAH SE HUM KUCH SIKH BHI LETE HE
ReplyDelete