Custom Spreadsheet Solutions
Productivity – powered by Excel

Switching it up with the SWITCH function

Switch is a useful function in Excel, that is a natural extension of writing about IFS last week. While it can handle up to 126 pairs, there are far better options if you have that many! SWITCH is probably a bit easier to understand than IFS but it only does exact matching (there is a […]