Excel's SWITCH is a logical function that is primarily used for data manipulation. It evaluates an expression against a list of values, and returns a result corresponding to the first matching ...

A Toggle Switch may read "Show Last Quarter." Clicking the button will reveal a column of previous sales figures and clicking the button again will hide the column. Click "View" in Excel's menu bar.

As with any function in Excel, you can combine these functions. You can place an IF statement within a SWITCH statement and vice versa. You can also insert them into other functions, such as SUM ...

Excel 3D Sum To Switch Between Tabs. An curved arrow pointing right. X ... Excel has a function for this too. Produced by Daniel Goodman and Walter Hickey. Originally published in July 2013.