Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
eed eed is offline
external usenet poster
 
Posts: 20
Default 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!!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return a Value Using Multiple Sources eed Excel Discussion (Misc queries) 3 September 10th 09 05:45 PM
Return a value based on multiple sources eed Excel Discussion (Misc queries) 1 September 9th 09 09:54 PM
Spreadsheet With Multiple Data Sources leimst Excel Worksheet Functions 2 September 28th 08 04:25 PM
filter data from multiple sources blackstar Excel Discussion (Misc queries) 0 October 25th 06 11:04 PM
Data Validation with Multiple Sources Jerkyboy Excel Discussion (Misc queries) 1 August 15th 06 10:49 PM


All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"