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

if you put the %-tage in A1
--
Gary's Student


"fivermsg" wrote:


at 90% of company goal i get paid 1.84$, for every 1% increase up to 99%
i get 9 cents more ... any formula out there that could solve this for
me?

ex- (90%- 1.84) , (91%- 1.93) , (92%- 2.02) and so on up to 99%..


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