Well, if you don't tell us ALL the details all we can do is go by what you
have posted. Tell us what *ALL* the Qty values are.

Biff

"Sum Limit and marking" wrote
in message ...
The only problem with this formula is that the qty that it goes up by
jumps
from 5,000 to 7,500. So this formula would not work because qty will not
always increase in increments of 500. Is there another formula?

Thanks.

"Biff" wrote:

Try this:

A10 = lookup value pages
B10 = lookup value quantity

This will work as long as the quantity in B10 does not excede the max
quantity listed in the table. For example, the max qty in the table is
2500.
As long as the lookup value qty is not greater than 2500 this will work:

=VLOOKUP(A10,A1:E5,CEILING(B10/500,1)+1,0)

Biff

"Sum Limit and marking"
wrote
in message ...
I need a formula that can help me do the following:

I have a pricing grid in the following format,

A B C D E
1 500 1000 2000 2500
2 64 $ 5 $ 6 $ 7 $ 8
3 80 $ 7 $ 8 $ 9 $10
4 96 $...............................
5 112 $...............................

The numbers in column A are the number pages
The numbers in row 1 are quantities of books

Is there a formula that would allow me to type in the number of pages,
and
quantity, and provide me with the correct pricing? For example, a 64
page
book at a quantity of 500 equals $5. Also if a book contains 80 pages
with a
quantity of 750, I need it to give me the next highest cost, which
would
be
$8. Any suggestions?