ThatExcelLife
New Member
- Joined
- Nov 2, 2017
- Messages
- 18
Hey Team!
Im stuck on a excel problem. Wonder if someone could give me some advice?
Its a simple scenario, but Im having trouble with the function.
Lets say you are going to get paid out based on the performance if your company. So any net income over $425,000 but under $725,000 you get 100% of it. Any additional NI over 725,000 you get 50% if it (also including the 100% of the difference between $425,000 and $725,000).
I would like to layer it as such....
<tbody>
</tbody>
What would the formulas be for the 2nd/3rd row such that it pays out the proper amount?
Thanks for your help!
Im stuck on a excel problem. Wonder if someone could give me some advice?
Its a simple scenario, but Im having trouble with the function.
Lets say you are going to get paid out based on the performance if your company. So any net income over $425,000 but under $725,000 you get 100% of it. Any additional NI over 725,000 you get 50% if it (also including the 100% of the difference between $425,000 and $725,000).
I would like to layer it as such....
1) Net Income | 419,000 |
2) 100% between 425,000-725,000 | ? |
3) 50% > 725,000 | ? |
4) Net Income after payout | = 1 - 2 - 3 |
<tbody>
</tbody>
What would the formulas be for the 2nd/3rd row such that it pays out the proper amount?
Thanks for your help!