IFS function is a new function added to Excel and only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions). Therefore when opening an IFS function containing excel workbook in an earlier version of excel, IFS function containing cells will be shown as #NAME? error notification and become unusable.
The basic function of this is to check pre-defined conditions and then return a corresponding value which are specified by the user.
The syntax used is explained below: