Does excel formulas support operations like switch or case?
Asked by pmnox in Microsoft Excel Spreadsheet Software, VB Script
Tags: Microsft, Excel, 2007, VB
Does excel formulas support operations like switch or case? I have to write a lot of long expression like if (X1=1, D5, IF(x2=2, D8, IF(x3=3,D9, etc. Is there any better way to write this formula? Is there something like swtich/ caseStart Free Trial
View this solution now by starting your
7-day free trial.
Setting up your free trial is quick, easy, and secure. We will return you to this solution,
unlocked, when you're done.
About this solution
Zones: Microsoft Excel Spreadsheet Software, VB Script