til next thread...thanks for trying....more power....
--
"Bright minds are blessed to those who share them.."-rsb.


"Ray" wrote:

IT WORKED!!!! Still don't see why but it does!!!!

THANK YOU ROMELSB!!!

"romelsb" wrote:

try this amigo....
place the blank quota in cell A1 : e.g. $1000.

PLACE THE ACCELERATOR FORMULA AS...ONE CELL AS U WISH....

=if(A1=150%,160%,IF(A1=130%,140%,IF(A1=110%,130 %,IF(A1=90%,100%,IF(A1=70%,70%,IF(A1=50%,50%,0% ))))))

REPLACE THE VALUES WITH CELL REFERENCES....


--
"Bright minds are blessed to those who share them.."-rsb.


"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