need help
 

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

need help
 

=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

need help
 

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

need help
 

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?


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

need help
 

Fiver,

I like Gary's solution. How about:

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

HTH

"fivermsg" wrote:


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?


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

need help
 

that doesn't work at all.. anyone one with another idea?


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