Good Afternoon,
Currently working out salesman annual bonus!! But the criteria list is long. Currently there are 5 salesman. The criteria are below, and different combinations of criteria do different things to the total bonus.
1) To get a bonus the sales man must have done $500,000 in revenue.
2) Any bonus is reduced by 50% if the company doesnt hit $2,000,000 revenue
3) The salesman gets a full bonus if however he makes $250,000 margin (regardless of the revenue in 1)
How do I write a forumla that takes into account these criteria?
Currently working out salesman annual bonus!! But the criteria list is long. Currently there are 5 salesman. The criteria are below, and different combinations of criteria do different things to the total bonus.
1) To get a bonus the sales man must have done $500,000 in revenue.
2) Any bonus is reduced by 50% if the company doesnt hit $2,000,000 revenue
3) The salesman gets a full bonus if however he makes $250,000 margin (regardless of the revenue in 1)
How do I write a forumla that takes into account these criteria?