🔹 AND Condition kya hai?

AND Condition ka matlab hai ki do ya do se zyada conditions ko ek saath satisfy hona zaroori hai.

Excel mein AND condition ka use tab hota hai jab humein data ko multiple conditions ke basis par filter ya analyze karna ho.

👉 Simple words mein:

AND = Sabhi conditions TRUE honi chahiye.

Agar ek bhi condition FALSE ho gayi, to overall result FALSE ho jayega.

📊 Simple Example

Maan lijiye student ke marks aur attendance hain:

Condition:

Marks > 80
AND
Attendance > 85%

Result:

Sirf Amit dono conditions satisfy karta hai.

🔹 AND Condition ka Basic Rule

Condition 1 = TRUE
AND
Condition 2 = TRUE
        ↓
     TRUE

Agar:

Condition 1 = TRUE
Condition 2 = FALSE

To:

TRUE AND FALSE = FALSE

📌 AND ka simple concept

Sabhi conditions correct → TRUE

Ek bhi condition wrong → FALSE

🧮 Excel mein AND Function

Excel mein AND condition ke liye AND() function bhi use kiya ja sakta hai.

Syntax:

=AND(condition1, condition2, ...)

Example:

=AND(A2>=50,B2>=75%)

Is formula ka matlab:

• A2 mein Marks 50 ya usse zyada hone chahiye
• B2 mein Attendance 75% ya usse zyada honi chahiye

Dono conditions satisfy hongi to result TRUE aayega.

🔍 Filtering mein AND Condition

Advanced Filter mein same row mein multiple criteria likhne par AND condition create hoti hai.

Example:

Iska meaning:

City = Delhi
AND
Marks > 80

Yaani record tabhi show hoga jab City Delhi bhi ho aur Marks 80 se zyada bhi hon.

📊 Business Example

Maan lijiye sales data hai:

Criteria:

Department = Sales
AND
Sales > ₹60,000

Result:

Rahul ke sales ₹90,000 hain, lekin department HR hai, isliye woh select nahi hoga.

🔄 AND vs OR Condition

Easy Trick:

AND = Dono/saare conditions

OR = Koi bhi ek condition

🎯 AND Condition ke Practical Uses

AND condition ka use:

• 👨‍🎓 Marks + Attendance check
• 💰 Salary + Department filtering
• 📊 Sales + Profit analysis
• 📦 Stock + Product category
• 👥 Employee records
• 🧾 Invoice checking
• 📅 Date + Amount filtering
• 🏆 Result/eligibility calculation

mein kiya ja sakta hai.