need help

F

fivermsg

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%..
 
D

Dominic

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
 
F

fivermsg

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?
 
D

Dominic

Fiver,

I like Gary's solution. How about:

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

HTH
 
Top