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

Regards,
Fred

"RC" wrote in message
...
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