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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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