Excel 2010 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Amount | Bonus | Bracket | Rate | Rate Differential | ||||
2 | 29,000,000 | 78,500.00 | $78,500 | 0 | 0 | 0.00% | |||
3 | 5,500,000 | 0.00 | 7,000,000 | 0.50% | 0.50% | ||||
4 | 18,222,222 | 53,055.56 | 17,000,000 | 0.25% | -0.25% | ||||
5 | 28,000,000 | 0.10% | -0.15% | ||||||
6 | |||||||||
7 | T201811a | 3d | |||||||
8 | |||||||||
3d |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | =SUMPRODUCT(--(A2>rB),A2-rB,rDiff) | |
C2 | =SUMPRODUCT(--(A2>{0;7000000;17000000;28000000}),A2-{0;7000000;17000000;28000000},{0;0.005;-0.0025;-0.0015}) | |
G2 | =F2-N(F1) | |
F3 | =5000/1000000 |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
rB | ='3d'!$E$2:$E$5 | |
rDiff | ='3d'!$G$2:$G$5 |