Excel For Data Analytics
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

Comments