Multiple conditions on Salary Structure with a single formula

This also worked for me.

base * 0.01 if (base >= 5000 and base <= 10000) else base * 0.02 if (base >= 10001 and base <= 15000) else 0

Thanks alot guys. So much appreciated.

2 Likes