calculating commissions

R

RC

I am looking for a formula that allows me to calculate payment to sales
people for comissions but with a draw.

Example

Sales person makes 1000 a month
Sales are 100,000 a month
He gets 1% of sales as commissions = 1000
So in this example, he does not get paid any commissions.

If he sold 200,000 he would get 1000 paid in commissiio.

I have it structured where the monthly draw is in one row and below I have
the comissions, but I want to show the ammount of commissions they get paid,
if they have to get paid.

Hope its clear. Its kind of hard explaining it in words.

THanks
 
F

Fred Smith

You probably want the following to calculate the pay (assumes sales in a1):
=max(1000,a1*1%)

Regards,
Fred
 
J

JoeU2004

RC said:
Sales person makes 1000 a month
Sales are 100,000 a month
He gets 1% of sales as commissions = 1000
So in this example, he does not get paid any commissions.
If he sold 200,000 he would get 1000 paid in commissiio.

Do you mean he gets 1% of sales less his salary?

If so, then:

=MAX(0, A1*1% - A2)

where A1 is sales and A2 is salary.


----- original message -----
 
S

smartin

RC said:
I am looking for a formula that allows me to calculate payment to sales
people for comissions but with a draw.

Example

Sales person makes 1000 a month
Sales are 100,000 a month
He gets 1% of sales as commissions = 1000
So in this example, he does not get paid any commissions.

If he sold 200,000 he would get 1000 paid in commissiio.

I have it structured where the monthly draw is in one row and below I have
the comissions, but I want to show the ammount of commissions they get paid,
if they have to get paid.

Hope its clear. Its kind of hard explaining it in words.

THanks

I interpreted your example as follows:

"A salesperson's commission rate is 1% of sales, but only to the extent
that the commission exceeds the salary. How do I calculate the commission?"

Then using named ranges to indicate Sales and Salary, this will be the
commission:

=MAX((Sales*0.01)-Salary,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top