calculating commissions

  • Thread starter Thread starter RC
  • Start date Start date
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
 
You probably want the following to calculate the pay (assumes sales in a1):
=max(1000,a1*1%)

Regards,
Fred
 
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.
Click to expand...

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 -----
 
Back
Top