Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
anyone help on this one?
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 |