Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |