Reformat your table like this
A B C
1 Range is: 1000 55%
2 0% 275
3 50% 50%
4 70% 70%
5 90% 100%
6 110% 130%
7 130% 140%
8 150% 160%

Formula in C2 gives you the result:
=$B$1*$C$1*IF(ISERROR(VLOOKUP($C$1,$A$2:$B$8,2)),0 ,VLOOKUP($C$1,$A$2:$B$8,2))

Regards,
Stefi

€žRay€� ezt Ã*rta:

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 isnt 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