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