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...


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=522155