Hello,
This is my first ever Thread!
I am having trouble working out the formula for the following problem:
Cells A1:J1 list the aggregate amount of $ in a bank account over time A1=0, B1=100, C1=400, D1=500, E1=900, F1=1000, G1=1000, H1:J1=1500
I am trying to produce a formula for A3:J3 which shows one off bonus payments as different target $ balances in the account are met. i.e $100, $500, $1000. Each one time bonus would be 1% of the target.
The result would therefore be:
A3=0, B3=1, C3=0, D3=5, E3=0, F3=10, G3=0 H3:J3=0
What is tripping me up is that in E1, while the balance is greater than the target of $500 I DO NOT want the formula to pay 1% in E3 as that bonus was paid in D3 for D1.
Any help would be greatly appreciated.
Alex
Bookmarks