Hi guys! I am really newbie in making my formulas in excel...I mean i can calculate with simple formulas and If statements, but i am really bad in other more complex stuff..So i need some help and i would appretiate it if you can help me with the following situation:
I have to make a formula with which to distribute a common sum in the cells to the right (the same row) according to a givven quota. After the common sum falls down below the givven quota, i have to write the ending balance in the last cell.
Here is the chart:
<tbody>
</tbody>
I would be really glad if you can help me with this problem because i cannot find a solution for it by myself!
Thanks a lot guys!
I have to make a formula with which to distribute a common sum in the cells to the right (the same row) according to a givven quota. After the common sum falls down below the givven quota, i have to write the ending balance in the last cell.
Here is the chart:
Common sum | Quota | Cell1 | Cell2 | Cell3 | Cell4 | Cell5 | |
5000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | |
4500 | 1000 | 1000 | 1000 | 1000 | 1000 | 500 |
<tbody>
</tbody>
I would be really glad if you can help me with this problem because i cannot find a solution for it by myself!
Thanks a lot guys!