The SWITCH function is a highly useful function which can be used for various applications with conditional splitting logic.
The SWITCH function is a highly useful function which can be used for various applications. This is newly introduced to Excel and it is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).