So far both these two examples haven't helped. Is theremanything else that
can be done?

"Ray" wrote:

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