How many promotions are there, Abarxax? I'm thinking maybe a lookup would be more flexible. See the attached example.
The thing is, you have to embed a number of IFs for each promotion level. A lookup is easier to maintain and to follow. But if you still want to learn how to embed IF statements one inside the other, feel free to insist
.