Setting the value of B1 from A1 using a formula?

  • Thread starter Thread starter Emil
  • Start date Start date
E

Emil

Hi,

Can you set the the value of a cell from a different cell using formula?

BR
Emil
 
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
 
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
 
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...
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
Calculate elapsed time excluding specific timeframe 10
Which function/s should I use? 5
setting cell values based on a 3rd cell 4
How to Show "+" for positive and "-" for negative 10
display a value from Sheet1-A1:A10 in Sheet2-B1 2
Nameing a function 1
Need Help 4

Back
Top