How can I change the commission rate% for different employees?

[evdesign]

For a Sales Commission Calculator
I would like to be able to change the commission rate% for different
employees. As well, I would like to adjust the rate automaticaly for
different goals. ex.: employee under $100,000=1% commission then employee
over $200,000=2% commission etc...

[Carim]

Hi,

Your mail is more of a wish than a precise request ...
From what you wrote, I would say it is feasible probably with sumproduct()
function ...

Carim

[Bryan Hessey]

Assuming your salesmancode is in column A, your sales in column B, your commission table in column F and G (0,100000,200000,300000,400000 in column F, 1,2,3,4,5 etc in column G), then

=VLOOKUP(SUMIF(A$1:A$9,A1,B$1:B$9),F$1:G$5,2,TRUE)
or
=VLOOKUP(SUMIF(A:A,A1,B:B),F:G,2,TRUE)

should achieve this.

--

For a Sales Commission Calculator
I would like to be able to change the commission rate% for different
employees. As well, I would like to adjust the rate automaticaly for
different goals. ex.: employee under $100,000=1% commission then employee
over $200,000=2% commission etc...

[George]

I believe that you can use in this case the If statement .eg if employee
payments <10000, 1%, if.....

Hope this will help

Ο χρήστης "evdesign" �*γγραψε:

> For a Sales Commission Calculator
> I would like to be able to change the commission rate% for different
> employees. As well, I would like to adjust the rate automaticaly for
> different goals. ex.: employee under $100,000=1% commission then employee
> over $200,000=2% commission etc...

[JE McGimpsey]

If the first $100K makes 1%, then the next $100K makes 2%, etc., take a
look at the examples here:

http://www.mcgimpsey.com/excel/variablerate.html

Use a different table for different employees.

In article <[email protected]>,
evdesign <[email protected]> wrote:

> For a Sales Commission Calculator
> I would like to be able to change the commission rate% for different
> employees. As well, I would like to adjust the rate automaticaly for
> different goals. ex.: employee under $100,000=1% commission then employee
> over $200,000=2% commission etc...