Piece of cake:

=IF(E10<90%, 0, IF(E10=135%, 11.1 + FLOOR(E10-134.999999%,5%)*12,
1.84+SUMPRODUCT(--(E10-{0.9,0.99,1.09,1.24}0),
--(E10-{0.9,0.99,1.09,1.24}), {9,2,14,5})))



In article ,
fivermsg
wrote:

I stopped at 99% cause at 100% it changes to an increase of 11 cents..
and again at 110% it changes to and increase of 25 cents, at 125% it
changes to an increase of 30 cents, at 135% it changes to 60 cents and
from then on i am looking at add in 60cents only for every 5% increase
as oppose to every percent. so at 135% till infinity at every 5%
increase there would be a increase of 60cents forever..

think you could make one for that.