Here's my problem. trying to create a formula within our commission sheet that will let my sales guys know what they will earn depending on what profit they earn.
structure as follows.

profit target say £5000,
Achieve 0-79% of target get 7.5%
Achieve 80-99% of target get 10%
Achieve 100%+ of target get 12.5%

i have managed to write the formula for the 1st and last using SUMIF but the middle formula is doing my head in. I am sure it is very simple but not for a simple chap like me.

any help would be greatly appreciated.

James.