software

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(E10lt;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: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=522155Try:

=IF(E10lt;0.9,0,1.84 INT(MOD(E10*10,1)*10)*0.09)

quot;fivermsgquot; wrote:

gt;
gt; at 90% of company goal i get paid 1.84$, for every full 1% increase up
gt; to 99% i get 9 cents more ... any formula out there that could solve
gt; this for me?
gt;
gt; ex- (90%- 1.84) , (91%- 1.93) , (92%- 2.02) and so on up to 99%..
gt;
gt; I got this formula earlier, IF(E10lt;0.9,0,1.84 (E10-0.9)*9) but it works
gt; as a gradual increase as oppose to just a flat 9 cents every 1 percent
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=522155
gt;
gt;


PERFECT!! thanks--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=522155
1 more thing... i am now trying to make that form work with the same
formula on a different scale and i can't get the if functions to work
like i have in the past..

ex IF(E10lt;0.9,0,1.84 INT(MOD(E10*10,1)*10)*0.09)
IF(E10lt;1,0,2.76 INT(MOD(E10*10,1)*10)*0.11)

I would like these to formulas to combine and of course many others,
but i would like the first if formulas to be omitted when the
percentage for 2nd if formula comes into play...--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=522155one way:

=IF(E10gt;=0.9, 1.84 MIN(E10 - 90%, 9%) * 0.09, 0)

Alternatively:

=(E10gt;=0.9)*(1.84 MIN(E10 - 90%, 9%) * 0.09)

Not sure why you stopped at 99% rather than 100% (or greater)...

In article gt;,
fivermsg gt; wrote:

gt; at 90% of company goal i get paid 1.84$, for every full 1% increase up
gt; to 99% i get 9 cents more ... any formula out there that could solve
gt; this for me?
gt;
gt; ex- (90%- 1.84) , (91%- 1.93) , (92%- 2.02) and so on up to 99%..
gt;
gt; I got this formula earlier, IF(E10lt;0.9,0,1.84 (E10-0.9)*9) but it works
gt; as a gradual increase as oppose to just a flat 9 cents every 1 percent

See

www.mcgimpsey.com/excel/variablerate.html

For instance:

=(SUMPRODUCT(--(E10-{0.9,0.99}gt;0),--(E10-{0.9,0.99}),{9,2}) 1.84) *
(E10gt;=90%)
In article gt;,
fivermsg gt;
wrote:

gt;
gt; 1 more thing... i am now trying to make that form work with the same
gt; formula on a different scale and i can't get the if functions to work
gt; like i have in the past..
gt;
gt; ex IF(E10lt;0.9,0,1.84 INT(MOD(E10*10,1)*10)*0.09)
gt; IF(E10lt;1,0,2.76 INT(MOD(E10*10,1)*10)*0.11)
gt;
gt; I would like these to formulas to combine and of course many others,
gt; but i would like the first if formulas to be omitted when the
gt; percentage for 2nd if formula comes into play...


I stopped at 99% cause at 100% it changes to an increase of 11 cents..
and again at 110% it changes to and increase of 25 cents, at 125% it
changes to an increase of 30 cents, at 135% it changes to 60 cents and
from then on i am looking at add in 60cents only for every 5% increase
as oppose to every percent. so at 135% till infinity at every 5%
increase there would be a increase of 60cents forever..

think you could make one for that.--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=522155Piece of cake:

=IF(E10lt;90%, 0, IF(E10gt;=135%, 11.1 FLOOR(E10-134.999999%,5%)*12,
1.84 SUMPRODUCT(--(E10-{0.9,0.99,1.09,1.24}gt;0),
--(E10-{0.9,0.99,1.09,1.24}), {9,2,14,5})))
In article gt;,
fivermsg gt;
wrote:

gt; I stopped at 99% cause at 100% it changes to an increase of 11 cents..
gt; and again at 110% it changes to and increase of 25 cents, at 125% it
gt; changes to an increase of 30 cents, at 135% it changes to 60 cents and
gt; from then on i am looking at add in 60cents only for every 5% increase
gt; as oppose to every percent. so at 135% till infinity at every 5%
gt; increase there would be a increase of 60cents forever..
gt;
gt; think you could make one for that.


K, that one does work but the only thing is that it add totals on
fractions of %'s.... i only want it to change on full percentages..
could you through and =int, in there somewhere??--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=522155
and that formula is inaccurate from the 90%-99% range--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=522155