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?