im trying to set up a formula to give me a number based on the criteria of a cell. My goal is setting up a work sheet for a bonus plan. Bonus are only payed at a higher percentage after a certain amount.

Example.

if bill gates sales are 1 billion dollars or more, then his bonus is 15%... or ... if bill gates sales are 1 billion dollars or less, his bonus will be 10%... ect ect...

any good Office Heads out there that can give this frustrated hardware engineer advice???? I can build them, trouble shoot them,, and repair them,, but when it comes to computer software and excell formulas,,, it might as well be an Apple... lol
thanks for any help.
Jim