if statements, and statements
Suggestion
change your left hand column to show the bottom end of each range only,
staring with 0, like so, in columns A & B
Row 1: 0 100
Row 2: 100 95
Row 3: 501 90
Row 4: 1001 85
Then use the formula
=VLOOKUP(550,$a$1:$b$4,2)
BTW, 550 is priced at 90, not 95
"Sum Limit and marking" wrote:
I have the following data:
QTY PRICE
<100 100
100-500 95
501-1000 90
1000-2500 85
A function that I am looking for is if I type in a quantity of 550 in a
cell, I want it to be able to retreive the correct pricing for whatever
quantity I request. In this case I want it to give me a price of 95. But I
also want to be able to use the same cell to request a quantity of 1000 and
to be able to give me back the correct price of 85.
Does anyone have a suggestion?
|