|HKD||Bonus 10%||Bonus Payable|
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.