View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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