How do I have a value appear when I reach a specific level?
 

I am making a spreadsheet for sales commission, and when a salesperson
reaches their sales target, I want to add in a bonus at that point and only
at that point.

For example, if they sell $1,000,000 worth of products, have the $5000 bonus
added to that paycheck at that point in time. Is there a way to structure a
formula to do this?

How do I have a value appear when I reach a specific level?
 

Drew, Try this,

=If(TotalSales1000000, Pay+5000,Pay)

Rick


"Drew" wrote in message
...
I am making a spreadsheet for sales commission, and when a salesperson
reaches their sales target, I want to add in a bonus at that point and
only
at that point.

For example, if they sell $1,000,000 worth of products, have the $5000
bonus
added to that paycheck at that point in time. Is there a way to structure
a
formula to do this?

How do I have a value appear when I reach a specific level?
 

Rick,
I believe I need to rephrase the question a little better. I have the sales
commission for the entire fiscal year and would like this bonus to appear as
a blip in the month in which the sales goal was reached. I realize that the
formula you gave would obviously give the proper total pay, but I'm looking
for a single entry in one cell beside the sales contract at which time they
exceeded the sales goal, not a modification to the total pay.
Thanks!
Drew

How do I have a value appear when I reach a specific level?
 

Drew, I take you have a column of monthly or yeraly sale results. So if the
total of month or yearly sales excedes the target value, the sale person
recieve the bonus. So for example if sale results are column E3 thru E25,
the formula for single cell could be E1= If(sum(E3:E25)1000000,
5000,"-")... I hope this what your lookin' for...

enjoy, Rick



"Drew" wrote in message
...
Rick,
I believe I need to rephrase the question a little better. I have the
sales
commission for the entire fiscal year and would like this bonus to appear
as
a blip in the month in which the sales goal was reached. I realize that
the
formula you gave would obviously give the proper total pay, but I'm
looking
for a single entry in one cell beside the sales contract at which time
they
exceeded the sales goal, not a modification to the total pay.
Thanks!
Drew