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?