jasonkgreen
Board Regular
- Joined
- Feb 21, 2013
- Messages
- 50
Below are the caps for each band/tier. Band 1 has a $20M cap. Any sales over $20M goes into Band 2. So if I hit $25M in sales, $20M goes in Band 1 and $5M goes in Band 2. How can I use a formula to accomplish this? I want any bands that are not reached to be blank.
A | B | C | D | E | F | G | H | I | J | K | |
1 | Target Bookings | $25,000,000 | |||||||||
2 | Role | AE | |||||||||
3 | |||||||||||
4 | Band 1 | Band 2 | Band 3 | Band 4 | Band 5 | ||||||
5 | Band Cap | $20,000,000 | $42,000,000 | $50,000,000 | $55,000,000 | $200,000,000 | |||||
6 | Band Allocation | 20,000,000 | 5,000,000 | | | |