Look at the VLOOKUP() function

Here's an excellent tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mattymoo" wrote in message ...
| I'm trying to develop a formula to calculate a sales team incentive bonus. A
| bonus amount is calculated based on sales made, but then is adjusted 3 months
| later based on the criteria below.
|
|
| Less than 50% of sales still on the books 0% payable
| 50% to 60% of sales 25%
| 61% to 70% of sales 50%
| 71% to 80% of sales 75%
| 81% to 90% of sales 100%
| Over 90% of sales 125%
|
| I'm afraid I don't know where to start - can anyone point me in the right
| direction?
|
| Thanks
|