software

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: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=521849=IF(A1lt;0.9,0,1.84 (A1-0.9)*9)

if you put the %-tage in A1
--
Gary's Studentquot;fivermsgquot; wrote:

gt;
gt; at 90% of company goal i get paid 1.84$, for every 1% increase up to 99%
gt; i get 9 cents more ... any formula out there that could solve this for
gt; me?
gt;
gt; ex- (90%- 1.84) , (91%- 1.93) , (92%- 2.02) and so on up to 99%..
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=521849
gt;
gt;

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

quot;fivermsgquot; wrote:

gt;
gt; at 90% of company goal i get paid 1.84$, for every 1% increase up to 99%
gt; i get 9 cents more ... any formula out there that could solve this for
gt; me?
gt;
gt; ex- (90%- 1.84) , (91%- 1.93) , (92%- 2.02) and so on up to 99%..
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=521849
gt;
gt;


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(A1lt;0.9,0,1.84 (A1-0.9)*9)

any help?--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=521849Fiver,

I like Gary's solution. How about:

=IF(A1lt;0.9,0,1.84 ROUNDDOWN((A1-0.9),2)*9)

HTH

quot;fivermsgquot; wrote:

gt;
gt; ok, this formula is working but it is continually counting even on mid
gt; percent.. i only wont it to cont on everytime 1 single percent is
gt; surpassed =IF(A1lt;0.9,0,1.84 (A1-0.9)*9)
gt;
gt; any help?
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=521849
gt;
gt;


that doesn't work at all.. anyone one with another idea?--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=521849