The formula for tax at 45% allows for a reduction in the allowance

[Blackwell]

Hello, I am trying to resolve this formula. I am ok with 20% and 40% tax, but I am struggling when the allowance is reduced after sales have increased over 100,000.
Sales 168,000
allow 12,570
net 155430

tax 20% 7,450
tax 405 47092
tax 45% ?

Sorry tried to load XL2BB but not working.

 

[Dave Patton]

Please expand your description and explanation of the calculations required.
What are the rates? How is the allowance calculated and how is it used in the calculation.

Can you show the calculations for several amounts and also the expected results.

 

[Blackwell]

Sorry, dave managed to sort it now thank you.