How to use IFS function in Excel

How to use IFS function in Excel. IFS function check multiple conditions and return the value on the basis of the first condition that returns TRUE. IFS function doesn't handle ELSE condition but in this video i will also cover how that can be done. This function is introduced in Excel 2019 so it can't be used in older versions. Visit & Subscribe channel: https://www.youtube.com/c/TechReflect... Here is the link to the practice file. You can download and use for your practice. https://drive.google.com/file/d/13ePh... This video lecture is part of the video series on Excel and it tools. Welcome to Tech Reflections (#techreflections) & I am Vikram. Let me know in comments below if this video helps you to start using IFS function. Other videos & playlist on the channel: SUMIF(), COUNTIF(), & IF()    • How to use VLOOKUP in Google Sheets | The ...   Playlists on this channel: Lookup Functions in Excel    • How Lookup Functions work?   Gantt Chart in Excel    • How to create Gantt Chart?   Excel Tools & Formulae    • Excel Tools & Formulae   Conditional Formatting:    • Excel - Conditional Formatting   Pivot Tables:    • Pivot Tables & its features   Powerpoint Hacks    • Powerpoint Hacks   #techreflections #ifsfunction #ifsfunctionexcel