| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
what are my options?
I use this format in one cell E11 to reference another cell E7 and to change
value dased on the name entered in E7 this is the format =IF(E7="sandy","10", IF(E7="bountiful","11")) I need to repeat this for 30 different options in the same cell. Is there a better way? Any other ways? Please help me. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with Excel Horizontal arrays with regional options using. | Excel Discussion (Misc queries) | |||
| Pivot Table Refresh Options | Excel Discussion (Misc queries) | |||
| default chart options | Charts and Charting in Excel | |||
| Excel Send To Options | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
Threaded Mode
