For the first example the formula works fine, thank you.

Can you amend your formula for this one below:

Example if you have a gross of 24300

Bracket 1 up-to 10,000 10,000.00 15% 1,500.00
Bracket 2 10,000.01 - 83,333 14,300.00 20% 2,860.00
Bracket 3 >83,333 0.00 30% 0.00
24,300.00 4,360.00