Setting the value of B1 from A1 using a formula?

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
 
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
 
E

Emil

Ok, thanks.

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
Merging from an Excel file with graphics 1
Calculate elapsed time excluding specific timeframe 10
Copy addition formula of non-consecutive horizontal cells 2
Show value from one cell in another cell if today falls between a date range 5
Select minimum with duplicate values to return column headings 3
If, Or, and 5

Top