Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a value based on 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: Level 1 Level 2 Level 3 Level 4 Title 1 Percentage Range 1 $X $X $X $X Percentage Range 2 $X $X $X $X Percentage Range 3 $X $X $X $X Percentage Range 4 $X $X $X $X Title 2 Percentage Range 1 $X $X $X $X Percentage Range 2 $X $X $X $X Percentage Range 3 $X $X $X $X Percentage Range 4 $X $X $X $X The variable/monthly info is in a basic spreadsheet format and contains the data that tells me who is entitled to receive a bonus, but ultimately I need to return the $AMOUNT they should receive based on the chart above + the monthly data. Help? Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a value based on multiple sources
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Search multiple worksheets and return value based on phone number | Excel Worksheet Functions | |||
Return specific values based on multiple crireria | Excel Discussion (Misc queries) | |||
How do I return a value based on multiple possible conditions? | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |