ETP tax capping formulas

Hi,
I am trying to put a formula in Australian ETP capping tax but I am having trouble. I have attached the spreadsheet in question should anyone like to help me. What I need is on the "ETP calc on TIL" worksheet cel D21 is to show the dollar amount upto $180K which includes the ETP payment.
I have tried numerous formulas but the one that is on the spreadsheet now is only working if the total whole of income is under the capping or if it is over the capping the ETP payment is less than the amount over the capping. If the total whole of income is greater than the ETP payment it is returning a negative amount.Redundancy Template WIP.xlsx
Thanking you in anticipation.
Belinda

Hi Special K,

Your formula partially works but i also need extra criteria.

In answer to your question in this instance the i would like a zero value to be return.

I will try and explain it the best i can but apologies if it is not clear (that is Australian tax for you).

If D18 is > $180,000 and amount over the $180,000 is greater than ETP payment (D17) result is to be zero (D21)
If D18 is > $180,000 but amount over the $180,000 is less than ETP payment (D17) D21 to return value upto capping of $180,000

i think i also need to add some if/or formulas but i cannot get it to work.

Thank you
Belinda

I changed the formual completely with a positive result. Issue is now resolved. Thanks for your help.