
Excel For Data Analytics
June 22, 2025 at 12:50 PM
📊 *Excel Formulas: IF, IFS & Nested IFs* ✅❌
1️⃣ *IF Function* – *Makes decisions based on conditions*
*Syntax:* `=IF(logical_test, value_if_true, value_if_false)`
📌 *Example:*
`=IF(A2>50, "Pass", "Fail")`
✔️ If A2 is more than 50, returns "Pass", else "Fail"
2️⃣ *Nested IF* – *IF inside another IF*
Useful for multiple conditions.
📌 *Example:*
`=IF(A2>=90, "A", IF(A2>=75, "B", IF(A2>=60, "C", "Fail")))`
✔️ Assigns grades based on score
3️⃣ *IFS Function* – *Simpler than nested IFs (Excel 2016+)*
*Syntax:* `=IFS(condition1, result1, condition2, result2, ...)`
📌 *Example:*
`=IFS(A2>=90, "A", A2>=75, "B", A2>=60, "C", A2<60, "Fail")`
✅ *When to Use What?*
- Use *IF* for simple yes/no decisions
- Use *Nested IF* or *IFS* for multiple ranges
- *IFS* makes long conditions cleaner & readable
💬 *Tap ❤️ for more!*
♥
❤️
👍
❤
11