| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statements, and statements
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Threaded Mode
