Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup ranges to find commision
I made two charts. The top one is how it looks and COL A & COL B refer to COL
D & E ranges and then come back with a dollar amount for Col C "COM" ie. the first row, ROW 2, Col A & Col B. Row 2, Col A is 2500. it is the lowest number of Row 2, Col A & B. Col A references Col D. It then looks for the number that is in that range and goes to the one right above it, or 2000. (2500 falls between 2000 & 3000) it then returns to Col C, Row 2 under "COM" $400.00. The correct answers are found in the graph below the first graph. [How do I reply through here to the one that tries to help? PLUS, I am having problems finding the response after it is sent. the link seems to be broken. My eMail is: THANKS!!] A B C D E F 1 LEFT RIGHT COM LEFT RIGHT DOLLAR 2 2500 3500 0 o 0 3 49 4005 250 250 $40.00 4 306 555 500 500 $100.00 5 948 3065 1000 1000 $200.00 6 1237 1894 2000 2000 $400.00 7 1573 3406 3000 3000 $600.00 8 4331 2749 4000 4000 $800.00 9 2021 243 5000 5000 $1,000.00 10 5000 5000 11 4001 4982 ANNSWER BELOW A B C D E F 1 LEFT RIGHT COM LEFT RIGHT DOLLAR 2 2500 3500 $400.00 0 o 0 3 49 4005 $0.00 250 250 $40.00 4 306 555 $40.00 500 500 $100.00 5 948 3065 $100.00 1000 1000 $200.00 6 1237 1894 $200.00 2000 2000 $400.00 7 1573 3406 $200.00 3000 3000 $600.00 8 4331 2749 $400.00 4000 4000 $800.00 9 2021 243 $0.00 5000 5000 $1,000.00 10 5000 5000 $1,000.00 11 4001 4982 $800.00 -- Thanks much Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commision calculation | Excel Worksheet Functions | |||
calculating commision on sales | New Users to Excel | |||
I'm looking for a tiered sales commision tracker | Excel Discussion (Misc queries) | |||
Calculating sales commision HELP!!!!!!! | Excel Worksheet Functions | |||
salary, hourly wage plus commision | Charts and Charting in Excel |