| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a formula based on another cell value
I am trying to use a different formula based on the value of cell.
So if the the cell value is "Store" use A1+B1+C1 If the cell value is "HQ" use A1+C1+F1 I know I can make a nice long IF formula (I actually need 3 different ones), but can I put a formulas in other cells and refer to a different one in based on the cell values? Or any other creative idea is welcomed. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Change formula based upon value of a different cell | Excel Worksheet Functions | |||
| How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| Change cell in formula based on date | Excel Discussion (Misc queries) | |||
Threaded Mode
