Hello board, I'm struggling with a formula to calculate the tax contribution where there are a number of different salary bandings and rates. I've manually typed out in column F what the answer should be but trying to get a formula in yellow cells so I don't have to keep recalculating! Help much appreciated!
|2||Annual salary banding||0.0%||2.5%||10.0%||15.0%||20.0%||22.5%||25.0%|
|3||Above:||Up to and including:||Above:||Up to and including:||Above:||Up to and including:||Above:||Up to and including:||Above:||Up to and including:||Above:||Up to and including:||Above:||Up to and including:||Above:|
|11||Annual Salary||Tax paid||Tax paid|