at 90% of company goal i get paid 1.84$, for every full 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%..
I got this formula earlier, IF(E10<0.9,0,1.84+(E10-0.9)*9) but it works
as a gradual increase as oppose to just a flat 9 cents every 1 percent
--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile:
http://www.excelforum.com/member.php...o&userid=32348
View this thread:
http://www.excelforum.com/showthread...hreadid=522155