I am trying to write an excel formula to find the percentage amount from a gross amount where they's a band of different percentages.
Find examples below of what I'm looking for:
Bracket Group Percentage Bracket 1 0 - 8,555.50 0%
Bracket 2 8,555.51 - 10,000 15%
Bracket 3 10,000 - 83,333 20%...