Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Use the IFS Function in Excel. That video is uploaded by Leila Gharani at 2020-07-09T02:00:03-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [AOO1AoTNdZk]
| Name | How to Use the IFS Function in Excel |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 09-07-2020 09:00:03 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses The IF function is one of the most popular functions in Excel. But writing nested Excel IF formulas in situations when more than 1 condition has to be checked can become cumbersome. If you have Excel 2019 or Microsoft 365 you can use the Excel IFS function instead. ⬇️ Download the workbook here: https://pages.xelplus.com/ifs-function-file 📈 What You'll Discover: - Excel's IFS Function: Learn to utilize IFS for various logical tests, replacing the need for nested IF statements. - Practical Examples: Follow along with two real-world scenarios, including salary comparisons and feedback emoji creation using IFS. - Custom Formatting: See how custom formatting can transform numerical weekdays into textual representations. 👨💻 In This Tutorial: - Salary Comparison: Compare salaries against a benchmark, categorizing them as higher, lower, or the same. - Feedback Emoji Creation: Convert employee feedback into emojis and add conditional formatting for a more engaging data presentation. - Bonus Tip: Explore the potential of VLOOKUP and XLOOKUP as alternatives to complex IFS or IF statements. In this tutorial I'll show you how easy it is to use this logical function when testing for multiple criteria. Your formulas will be much easier to read. Since the IFS function only checks for the TRUE condition, how can you include an else condition in IFS? There is a simple way around this. Check it out at minute 02:42. I'll also show you how you can use conditional formatting in Excel (on emojis) to visualize results better. As a special bonus tip I'll cover how you could replace the Nested IF formulas with the VLOOKUP function. Link to Excel IF formula: https://youtu.be/KkTaQ5OjAGc Link to VLOOKUP video: https://youtu.be/hwL6KKJP-_I Link to XLOOKUP video: https://youtu.be/xnLvEhXWSas ★ My Online Excel Courses ► https://www.xelplus.com/courses/ 00:00 Excel IFS instead of Nested IF formulas 00:37 Testing for 3 conditions with IFS 02:42 How to include "else" statement in IFS 04:40 Excel IFS with conditionally formatted emojis 09:06 Use Excel VLOOKUP instead of Nested IF ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel AOO1AoTNdZk |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | XelPlus | Microsoft 365 | Excel 365 | Excel IFS | Excel IFS function | IFS | Nested IF in excel | excel if multiple conditions | how to use IFS with else statement | IFS with emoji | VLOOKUP instead of IFS | how to replace IFS with VLOOKUP | Excel with emoji | conditional formatting excel |
