Forum Discussion
Solved
If statement with tiers
Hello - I am looking for a little assistance with a IF statement. Basically I have 3 tiers and I want a formula that allows someone to enter a number in a box and it applies that number across t...
It might be better to enter the thresholds in cells, but without those:
In B1: =MIN(100,E1)
In B2: =MIN(50,E1-B1)
In B3: =E1-B1-B2