Urgent Excel help needed PLEASE!!!!
It might be basic stuff but I just can't get my head around how I create relevant formulae for the following. ANy help would be much appreciated.
I have two profit figures, one before making changes and one after making changes to a business structure.
I want to pay the person who makes the changes a banded reward structure.
0-10% = 5% of the uplift
11-20% = 10%
21-30% = 15%
31-40 = 20%
41+ = 25%
Whatever I do I just can't seem to get a suitable formula in place and I'm no Excel wizard.
Any help would be hugely appreciated
(For the sake of it and to make it easier to explain can we work on the basis that Profit 1 = Cell A1, profit 2 = Cell A2)