Notifications
Clear all
Topic starter
Hi,
I am trying to complete a formula which calculates taxes on payroll. I would like the formula in the attached workbook for the 33.5% calculation to not return a negative amount once the taxable amount for that band is below the threshold. Hope I have explained what I would like help with. I have provided different examples to show what is happening.
Thanks for any assistance.
Candid
Posted : 01/09/2018 7:02 pm
Hi Candid
You can try this:
In cell D27 enter =IF(D25>50000,15000*0.335,IF(AND((D25-35000)>0,D25<50000),(D25-35000)*0.335,0))
Hope this helps.
Sunny
Posted : 01/09/2018 9:17 pm
Topic starter
Hi Sunny,
Yes, that helps.
Thanks you so much.
Candid
Posted : 02/09/2018 12:24 pm
