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