=A1*1000*LOOKUP(A1,{0,0.5,0.7,0.9,1.1,1.3,1.5},{0, 0.5,0.7,1,1.3,1.4,1.6})

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ray" wrote in message
...
Hello,

I am tried to work out a compensation calculator with accelerators and am
having issues.

100% of quota is $1,000

Range is:
<49% (0%)
50%-69% (50%)
70%-89% (70%)
90%-109% (100%)
110%-129% (130%)
130%-149% (140%)
150%< (160%)

So if the result is 55% of quota is reached then take (1000*55%) then
multiply that by the decelerator of 50%; but if 112% is reached then take
(100*112%) then multiply that be the accelerator of 130%.

All of this needs to be in one cell.

This is what I have so far, but it isn't working


=IF(I16<49%,((B28*I16)*H28),IF(69%I1650%,((B29*I 16)*H29),IF(70%<I16<89%,((
B30*I16)*H30),IF(90%<I16<109%,((B31*I16)*H31),))))

Thank you,

Ray