E
Emil
Hi,
Can you set the the value of a cell from a different cell using formula?
BR
Emil
Can you set the the value of a cell from a different cell using formula?
BR
Emil
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Hi
If I understand you correctly, just type = and then click on the other
cell and hit Enter. The formula it creates will be something like
=A2
If I understand you correctly, just type = and then click on the other
cell and hit Enter. The formula it creates will be something like
=A2
C
Chip Pearson
Emil,
A formula in a cell can only return a value to that cell. It
cannot change the value of any other cell. Thus, a formula in A1
cannot change the value of B1.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
A formula in a cell can only return a value to that cell. It
cannot change the value of any other cell. Thus, a formula in A1
cannot change the value of B1.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
E
Emil
Ok, thanks.
Emil
Emil
Chip Pearson said:Emil,
A formula in a cell can only return a value to that cell. It
cannot change the value of any other cell. Thus, a formula in A1
cannot change the value of B1.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com