Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formula Value
Is there a formula to show me the formula in another cell? I want to use the
value in one cell in a formula in another cell. For example, On Sheet1, cell E15 = "Amoritizations!$U$226" In cell F15, I want the following = OFFSET(Amoritizations!$U$226,1,0) except I want to replace "Amoritizations!$U$226" with something like Formula(E15) where "Formula" is the way to look at the formula value in cell E15. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formula Value
Hi Tim,
Use the INDIRECT() function. Use the function wizard for details -- Kind regards, Niek Otten Microsoft MVP - Excel "Tim Caldwell" wrote in message ... | Is there a formula to show me the formula in another cell? I want to use the | value in one cell in a formula in another cell. | | For example, | | On Sheet1, cell E15 = "Amoritizations!$U$226" | | In cell F15, I want the following = OFFSET(Amoritizations!$U$226,1,0) except | I want to replace "Amoritizations!$U$226" with something like Formula(E15) | where "Formula" is the way to look at the formula value in cell E15. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |