Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Building Formulas
I am trying to build a formula where I can have one input cell and have the
formula look up that value in a table and provide a corresponding value. Example: Someone is going to buy 30 widgets and there are discounted rates depending on the number of widgets purchased. I want to be able to put in 30 and have the formula look up that number and give me the corresponding rate. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Building a table with formulas rather than a macro | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |