Fiver,

I'd use a lookup table. Check out Debra's site at www.contextures.com

Basically, create a table with the percentage and amount as listed in your
post. Then use something like =a1*vlookup(b1,lookuptable,2,false)

a1 would be your unit count (assuming that this is how you will use your
percentage), b1 is your percentage for this value, lookuptable is the name
used for your lookup table, and false means find an exact match.

HTH

"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