Posts

Excel Formulas List in Hindi + PDF Download | MS Excel Formulas with Examples

Agar aap Excel Formulas PDF in Hindi download karna chahte hain ya RSCIT exam ke liye important Excel formulas ki list dhoond rahe hain, to yah page aapke liye complete guide hai.

Yahan humne 50 sabse jyada use hone wale MS Excel formulas ko Hindi explanation aur example ke saath diya hai — jo RSCIT exam aur daily computer work dono me useful hain.

📌 Basic Excel Formulas (बेसिक सूत्र)

Formula	काम	Example
=SUM()	संख्याओं का योग	=SUM(A1:A10)
=AVERAGE()	औसत निकालना	=AVERAGE(A1:A10)
=COUNT()	संख्या गिनना	=COUNT(A1:A10)
=COUNTA()	खाली छोड़कर गिनना	=COUNTA(A1:A10)
=MAX()	सबसे बड़ी संख्या	=MAX(A1:A10)
=MIN()	सबसे छोटी संख्या	=MIN(A1:A10)
=ROUND()	राउंड करना	=ROUND(A1,2)
=ABS()	Absolute value	=ABS(A1)
=SQRT()	वर्गमूल	=SQRT(A1)
=POWER()	घात	=POWER(A1,2)

📌 Logical Formulas

Formula	काम	Example
=IF()	शर्त लगाना	=IF(A1>50,"Pass","Fail")
=AND()	दोनों शर्त सही	=AND(A1>50,B1>50)
=OR()	कोई एक शर्त सही	=OR(A1>50,B1>50)
=NOT()	उल्टा परिणाम	=NOT(A1>50)
=IFERROR()	त्रुटि संभालना	=IFERROR(A1/B1,"Error")

📌 Text Formulas

Formula	काम	Example
=LEFT()	बाएँ से अक्षर	=LEFT(A1,4)
=RIGHT()	दाएँ से अक्षर	=RIGHT(A1,4)
=MID()	बीच से अक्षर	=MID(A1,2,4)
=LEN()	अक्षर गिनना	=LEN(A1)
=TRIM()	Extra space हटाना	=TRIM(A1)
=UPPER()	बड़े अक्षर	=UPPER(A1)
=LOWER()	छोटे अक्षर	=LOWER(A1)
=PROPER()	पहला अक्षर बड़ा	=PROPER(A1)
=CONCAT()	जोड़ना	=CONCAT(A1,B1)
=TEXT()	Format बदलना	=TEXT(A1,"dd-mm-yyyy")

📌 Date & Time Formulas

Formula	काम	Example
=TODAY()	आज की तारीख	=TODAY()
=NOW()	तारीख + समय	=NOW()
=DATE()	तारीख बनाना	=DATE(2025,2,23)
=YEAR()	साल निकालना	=YEAR(A1)
=MONTH()	महीना निकालना	=MONTH(A1)
=DAY()	दिन निकालना	=DAY(A1)
=TIME()	समय बनाना	=TIME(10,30,0)
=HOUR()	घंटा निकालना	=HOUR(A1)
=MINUTE()	मिनट निकालना	=MINUTE(A1)
=SECOND()	सेकंड निकालना	=SECOND(A1)

📌 Lookup & Advanced Formulas

Formula	काम	Example
=VLOOKUP()	तालिका में खोज	=VLOOKUP(A1,A2:B10,2,FALSE)
=HLOOKUP()	क्षैतिज खोज	=HLOOKUP(A1,A2:D5,2,FALSE)
=XLOOKUP()	नया lookup	=XLOOKUP(A1,A2:A10,B2:B10)
=INDEX()	मान निकालना	=INDEX(A1:A10,2)
=MATCH()	स्थान ढूँढना	=MATCH(A1,A1:A10,0)
=COUNTIF()	शर्त के साथ गिनना	=COUNTIF(A1:A10,">50")
=SUMIF()	शर्त के साथ योग	=SUMIF(A1:A10,">50")
=AVERAGEIF()	शर्त के साथ औसत	=AVERAGEIF(A1:A10,">50")
=COUNTIFS()	कई शर्तें	=COUNTIFS(A1:A10,">50",B1:B10,"Yes")
=SUMIFS()	कई शर्तों के साथ योग	=SUMIFS(A1:A10,B1:B10,"Yes")

📥 Download Excel Formulas PDF in Hindi

Aap yahan se 50 Most Important Excel Formulas PDF in Hindi free me download kar sakte hain.

📌 PDF me sabhi formulas Hindi explanation aur examples ke saath diye gaye hain.
📌 RSCIT exam preparation ke liye perfect.

👉 Download RSCIT Exam Formulas PDF

❓Frequently Asked Questions

Q1: Excel me sabse important formula kaunsa hai?
SUM, IF, VLOOKUP aur COUNTIF sabse jyada use hone wale formulas hain.

Q2: Excel formulas PDF in Hindi kaise download kare?
Upar diye gaye download button par click karke aap PDF download kar sakte hain.

Q3: Kya ye formulas RSCIT exam me aate hain?
Haan, inme se kai formulas RSCIT exam me frequently pooche jaate hain.

MS Excel ke ye 50 sabse important formulas aapke liye daily computer work aur RSCIT exam preparation dono me bahut upyogi sabit honge. Agar aap in formulas ko samajhkar practice karte hain, to Excel aapke liye kaafi aasan ho jayega.

Main 2014 se ITGK center par students ko RSCIT aur computer courses padhata aa raha hoon aur 2019 se ilearnrscit.com par regular updated study material share kar raha hoon. In formulas ki list bhi students ke practical experience aur exam pattern ko dhyan me rakhkar taiyar ki gayi hai.

Agar aap RSCIT exam ki tayari kar rahe hain, to is page ko bookmark zarur karein aur PDF download karke regular practice karein.

Aapke liye aur bhi useful resources:

Regular updates ke liye website visit karte rahein — yahan aapko RSCIT se related har important information simple Hindi me milti rahegi.

Agar aapko ye post helpful lagi ho to ise apne doston ke saath share zarur karein 😊

iLearnRSCIT.com