View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nickname nickname is offline
external usenet poster
 
Posts: 10
Default referring to formula in a non active cell from active cell

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.