I'm hoping someone can help me with an excel formula issue. I'm trying to create a spreadsheet that can calculate a bonus based on three different tiers. Each tier has two objectives that must be met to reach that bonus. So, for example, if net profit is $1,000 and gross profit is 15%, then bonus is $500. Next tier would be net profit of $1,500 and gross profit of 18% equals a bonus of $1000 and so on. I'm trying to create a spreadsheet that would allow the user to type in the net profit and gross profit and it will automatically calculate the bonus. Can anyone help with the correct excel formula to use? Any help would be greatly appreciated!