D
daniel4124
I hope this is the place to post this....i am a newbie here! so if
make mistakes please accept my apologies in advance.
I want to create a table (using excell 2003) that calculate
commissions (for instance). Something like
on the first 100 10%
on the second 100 15%
on the third 100 20%
on the forth 100 25% and so on........
I would like to have the amounts and percentages change easily with
minimun amount of entry work (say for instance if the amount changes t
the first 150 instead of 100 or if the percentage changes from 10% t
11%). I would like to see columns show the name of the employee, th
total gross amount, $amount of commissions, $amount for business, tota
amount (to act as a proof).
Hope someone can help with this....i am away from home so i cannot eve
begin to dope this out with manuals.
Thanks in advance for any help and hope this benefits someone else i
the process.
Warmest Regards
Danie
make mistakes please accept my apologies in advance.
I want to create a table (using excell 2003) that calculate
commissions (for instance). Something like
on the first 100 10%
on the second 100 15%
on the third 100 20%
on the forth 100 25% and so on........
I would like to have the amounts and percentages change easily with
minimun amount of entry work (say for instance if the amount changes t
the first 150 instead of 100 or if the percentage changes from 10% t
11%). I would like to see columns show the name of the employee, th
total gross amount, $amount of commissions, $amount for business, tota
amount (to act as a proof).
Hope someone can help with this....i am away from home so i cannot eve
begin to dope this out with manuals.
Thanks in advance for any help and hope this benefits someone else i
the process.
Warmest Regards
Danie