Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to refer to the formula from (not value of) a non
active cell into a formula in an active cell? For example, A1: =A2+A3 [non active cell] Would like to insert above formula (A2+A3) into active cell's formula by referring to A1, non active cell. B1: = ?function?(A1) + B4 + B5 [active cell] Here are the values of cells: B2 = 2 B3 = 3 B4 = 4 B5 = 5 So the value of B1 would be 2+3+4+5 or 14. Thanks in advance for any guidance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to use the active cell in an Excel formula | Excel Worksheet Functions | |||
Active cell | Excel Discussion (Misc queries) | |||
Active Cell To Change Formula | Excel Discussion (Misc queries) | |||
how to copy a trendline formula into an active cell ? | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) |