Return a value based on multiple sources

E

eed

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a Value Using Multiple Sources 3
Return a Value Using Multiple Sources 0
PLEASE HELP! Return a Value Using Multiple Sources 4
Auto Merge text from multiple sources 0
How do I Return a Value Using Multiple Criteria? 1
Style Header Reformatted 3
Need To Track Advertising 0
Changing range based on Date 5

Top