Fiver,

I like Gary's solution. How about:

=IF(A1<0.9,0,1.84+ROUNDDOWN((A1-0.9),2)*9)

HTH

"fivermsg" wrote:


ok, this formula is working but it is continually counting even on mid
percent.. i only wont it to cont on everytime 1 single percent is
surpassed =IF(A1<0.9,0,1.84+(A1-0.9)*9)

any help?


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