In this video, I show how to use the SWITCH function in Google Sheets. With this function, you can create a switch statement in your spreadsheet that will check a value or expression against multiple cases. This function is somewhat similar to nesting multiple IF statements together, however, it is a much simpler formula
Read through the full tutorial here:
https://www.modernschoolbus.com/switc...
Timestamps:
00:00 Intro
00:47 SWITCH Syntax
2:52 Using the SWITCH Function