Chapter 35: IFS FUNCTION | Don't use Nested IF

IFS function is available in Excel 2019 and 365 and it is replacement of Nested If fucntion.
Check Nested If Function: • Module-2 Chapter: 17 -...
And Also Check out IF and IFS Function
• Module-2 Chapter: 19 I...

[@muhammadriyajuddin7073]

Great formula,
but I'm missing something due to Excel 2007

[@TechMe.79]

Please upgrade to Excel 2019 or 365 to use advanced functions like dynamic array functions