Here's a fun one. Incentive formula in tiered structure.

Originally Posted by FDibbins

if you modify your 1st table, by putting in 0 in B1, 25000 ib c1 etc across, then you can use this, copied down and across...
=IF($C23="","",$C23*0.0025+INDEX($B$1:$G$8,MATCH(D$11,$B$1:$B$8,0),MATCH($C23,$B$1:$G$1,1)+1))

I dont quite agree with the answers you have, so please check both your answers and mine?

You forgot to multiply $C23 by the 5%, 10%, 15%, 20%, or 25% (D11 thru H11).

I used: $C23*(1+D$11)*0.25%