anyone help on this one?
one way:
=IF(E10=0.9, 1.84 + MIN(E10 - 90%, 9%) * 0.09, 0)
Alternatively:
=(E10=0.9)*(1.84 + MIN(E10 - 90%, 9%) * 0.09)
Not sure why you stopped at 99% rather than 100% (or greater)...
In article ,
fivermsg wrote:
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(E10<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
|