#SWITCH #EXCEL #Excel_2019
SWITCH function enables you to return result on the basis of multiple premises (not the logical tests) and a default value set by use if the match is not found. This is available in EXCEL 2019 and above version i.e. MS365 The google drive link of the practice sheet is as under:-
https://docs.google.com/spreadsheets/...