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