Does Excel have a "Switch" function or anything similar?

[DashboardNovice]

I don't like the idea of using nested IFs. When writing programming code, if you have multiple possible outcomes, instead of using nested IF statements, you can use "Switch".

My question is this. Does Excel (not VBA) have a function similar to switch?

The only thing I can think of is the CHOOSE function. Any other ideas?

 

[NARAYANK991]

Hi ,

It depends on what you wish to do with the SWITCH statement ; just as the CHOOSE function returns one out of many outputs based on an input parameter , so also the INDEX function can return one out of many possible outputs.

Probably if you can give a concrete example of what you wish to do ?

Narayan

 

[Hui]

You can also add controls to a worksheet
Some of these controls act as Switches (Check Boxes and Option Buttons)
Refer: http://chandoo.org/wp/2011/03/30/form-controls/