Return a Value Using Multiple Sources
I need to return a value (a $AMOUNT) based on the following information:
TITLE, LEVEL 1 2 3 or 4, and a percentage range. Ex: If the [TITLE, ie: Store Manager] exceeds their sales plan by a [PERCENTAGE RANGE, ie: 1-5%], then they receive a certain bonus [$AMOUNT] based on their [LEVEL]. The static information is currently set up in a chart as follows: Store Manager Level 1 Level 2 Level 3 Level 4 Exceeds Sales Plan 5.00%-6.99% $X $X $X $X Exceeds Sales Plan 7.00%-8.99% $X $X $X $X Exceeds Sales Plan 9.00%-10.99% $X $X $X $X Exceeds Sales Plan 11.00% + $X $X $X $X Associate Manager Level 1 Level 2 Level 3 Level 4 Exceeds Sales Plan 5.00%-6.99% $X $X $X $X Exceeds Sales Plan 7.00%-8.99% $X $X $X $X Exceeds Sales Plan 9.00%-10.99% $X $X $X $X Exceeds Sales Plan 11.00% + $X $X $X $X The info above is in SHEET 1. 'Store Manager' is in A1. Levels 1-4 for store manager are in B1-E1 The variable/monthly info is on SHEET 1 and contains the info that tells me who is entitled to receive a bonus, but ultimately I need to return the $AMOUNT (Bonus Amount column) they should receive based on the chart above. The TITLE heading is A1, % Over Sales Plan is in A2, etc. TITLE % OVER SALES PLAN Bonus Level Bonus Amount Store Manager 5.00% 2 Assistant Mgr 11.00% 4 Help? Thanks!! |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com