Switch formula not giving expected results

[donnell]

I am trying to return a number if the effective tax rate is between a certain range. Gven that there are multiple criteria, I am using a Switch formula:

This formula is only returning "1" if below 25 (which is what i want) but otherwise "2" and not taking into account the other criteria. Any ideas why or how to fix this? I've attached the workflow for context - thanks!

[atcodedog05 · Accepted solution]

Hi @donnell 

I personally feel switch cannot be used over here and usage is also wrong. 

Right use of switch is the one mentioned in its syntax. It only compares equal to like Value= A or Value =B

It doesnt work on condition.

Switch(Value,Default,
Case1,Result1,...,
CaseN,ResultN)

Please use elseif block for this scenario.

IF condition THEN t 
ELSEIF condition2 THEN t2 
ELSE f ENDIF

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[donnell]

Thanks @atcodedog05 - I had tried the If statement with multiple ELSEIFs and it hadn't worked but I obviously had an error in there somewhere - it is working now - thanks!

[atcodedog05]

Glad to hear 🙂

Happy to help 🙂 @donnell 

Cheers and Happy Analyzing 😀

[Mohit_17]

Hi @donnell 

could you please share what was the error in your formula, I am experiencing the same issue, and the switch is not working for me. I have attached the screenshot. Thanks.