Profit/Loss | ||
HKD | Bonus 10% | Bonus Payable |
633,122.15 | 63,312.21 | 63,312.21 |
2,409,094.43 | 240,909.44 | 240,909.44 |
133,312.37 | 13,331.24 | 13,331.24 |
362,337.61 | 36,233.76 | 36,233.76 |
(1,945,668.04) | (194,566.80) | 0.00 |
587,245.31 | 58,724.53 | 0.00 |
1,769,208.71 | 176,920.87 | 41,078.60 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Hello, I have a table as above.
I want to enter a formula into the "Bonus Payable" column so that I don't have to enter the number manually.
The amounts under Bonus Payable is calculated as follows.
If the profit is positive, then the bonus payable will simply be 10% of the profit.
If it's a loss, then there will be no bonus payable.
If next month has a profit, bonus will only be paid if 10% of it exceeds 10% of the loss incurred from previous month.
So 41,078.60 is calculated as (176,920.87 + 58,724.53 - 194,566.80) = 41,078.60.
Thanks v