See

http://www.mcgimpsey.com/excel/variablerate.html

For instance:

=(SUMPRODUCT(--(E10-{0.9,0.99}0),--(E10-{0.9,0.99}),{9,2}) +1.84) *
(E10=90%)



In article ,
fivermsg
wrote:


1 more thing... i am now trying to make that form work with the same
formula on a different scale and i can't get the if functions to work
like i have in the past..

ex IF(E10<0.9,0,1.84+INT(MOD(E10*10,1)*10)*0.09)
IF(E10<1,0,2.76+INT(MOD(E10*10,1)*10)*0.11)

I would like these to formulas to combine and of course many others,
but i would like the first if formulas to be omitted when the
percentage for 2nd if formula comes into play...