| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I make this work? =LOOKUP(A2,{any number},{5,6,7,10})
I am trying to use a lookup formula to calculate the price, The dollar
amount could be from zero on up to $150.00. Can this be done as a lookup? Thanks so much for any tips. Regards, Susan range price 0 $5 0.01-1.00 $6 1.01-2.00 $7 2.01-5.00 $10 5.01-7.00 $12 7.01-10.00 $15 up to 145.01-150.00 $155 (table contains 36 values) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make Excel Macros created on PC work on Macintosh? | Excel Worksheet Functions | |||
| Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
| Make Autofit row height work with merged cells | Excel Discussion (Misc queries) | |||
| How do I make 'save as web page' with interactivity work properly. | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Threaded Mode
