No, just enter the formula as it is.
And if you enter 15.000 in A12 the result will be 2.

Per Erik

On Mon, 5 Mar 2007 14:25:08 -0800, DCS
wrote:

it should be 10,001 in line two.

I do not need to calculate the revenue just need to bring up the correct
price based on the volume.

So would I just get rid of the multiplication?


"Per Erik Midtrød" wrote:

IF the given volume is in A12 and your table is in
A1:C4 then the following formula should work:
= SUMPRODUCT((A2:A4<=A12)*(B2:B4=A12)*(C2:C4))

Just keep in mind that I assumed there is a typo, since 10.000 is in
two ranges. If it is not and someone was to buy exactly 10.000 the
formula will return 5...

Best regards
Per Erik


On Mon, 5 Mar 2007 14:04:10 -0800, DCS
wrote:

I am trying to use the lookup function to display the price of a widget with
a given volume that I will use as an input cell. The issue the volume is a
range using two cells. See below


Volume Price
- 10,000 3.00
10,000 - 50,000 2.00
50,001 - 100,000 1.00

How do I setup a lookup formula to accomplish this? Keep in mind the ranges
of volume per price are in two separate cells. So 0 and 10,000 have their
own cell.