| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula so if reference is selected, a specific value is returned
From a dropdown list I want to select from a range of set levels that have
specific values beside them. So when the range (0 - 600) is selected, $500 appears in another cell. eg: 0 - 600 $500 600 - 1200 $1000 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula so if reference is selected, a specific value is returned
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Boss" wrote in message ... From a dropdown list I want to select from a range of set levels that have specific values beside them. So when the range (0 - 600) is selected, $500 appears in another cell. eg: 0 - 600 $500 600 - 1200 $1000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limit characters returned a cell reference | Excel Worksheet Functions | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| Need reference in adjacent column returned | Excel Worksheet Functions | |||
| Specific cell selected when sheet opens...how??? | Excel Discussion (Misc queries) | |||
| I need specific numbers to be a selected color everytime | Excel Discussion (Misc queries) | |||
Linear Mode
