Sales Commission

[kmaient]

As per attached file I tried for find out the best result; But I failed. So, I came to you all Experts -


I want result in cell 'C12' sales commission where are the following condition required -

1. Sales up to 25,000.00; Sale Commission would be 0.20% and not less than 50.00
2. Sales from 25,000+ up to 100,000.00; Sale Commission would be 0.15%; and not less than 100.00
3. Sales from 100,000+ up to 500,000.00; Sale Commission would be 0.10%; and not less than 200.00
3. Sales 500,000.00 + ; Sales Commission would be Minimum 1000/- & Maximum 2000/-


Your help will be highly appreciated.

Regards

kmai

[KOKOSEK]

Into C12:

Please Login or Register  to view this content.

without testing.

[kmaient]

No, not working.

when I input 25,000 it's shows result 100 instead of 50
when I input 100,000 it's shows result 200 instead of 100
when I input 500,000 it's shows result 1,000 instead of 500 &
when I input 2,100,000 it's shows result 2,100 instead of 2,000

Regards

KMAI

[bebo021999]

Not understand 100%, but try:

Please Login or Register  to view this content.

[kmaient]

Yes! It's working after a bit correction! I just remove '50' after '(C11<B7)'