| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using one cells formula in multiple other cells
Hello,
Is there any way to type a generic formula into a cell and then reference that cell in others to calculate data. I wish to do this so as to be able to change the formulas in a large spreadsheet without changing every cells formula. For example is it possible to have cell D5 contain the formula =B5+C5. Then have G10 perform the calculation E10+F10. Then if I wanted to I could change the formula in D5 to =B5*C5 and G10's value would change from the addition of E10 and F10 to the multiplication of them. I don't know if this is possible, but any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing a formula in multiple cells | Excel Worksheet Functions | |||
| Look up formula, multiple cells | Excel Discussion (Misc queries) | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| apply a formula to multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
