If or Switch statment based in percentage value

[Ait-james]

Hello,

I would like to to apply a condition based to percent value I have, how I can do that please ?

When I tried this formul I got an error msg.

[FirasAlramli · Accepted solution]

replace 20% by 0.20

[Ait-james]

thank you, it's working well !

[Venkata17]

How to use Switch function for 20 to 40 Percentage and 40 to 100 percentage in same function.