How to refer the results of one cell to another cell?

D

Dave Boland

If I have the following spreadsheet, how do I get a
calculation in D1 to put the value in A1 as well (as D1)?

A B C D
1| 2 3 =B1 + C1
2|
3|

I don't want to put the formula into A1, just the value --
'5' in this case.


Thanks,
Dave
 
G

Gary''s Student

Select D1 then Edit > Copy
Select A1 then Edit Paste Special and check value.
 
D

Dave Boland

Gary,

Oops! I should have said that I want this to be automatic,
not Copy and Paste -- sorry! The only way I can get this to
work is to have A1 linked to D1, but that is a problem
because Column A already has values in it we need to keep.
The actual function is an IF and an computation that puts a
value into the corresponding A row if there is data in
another column. Thus the need for an automatic way to do
this so if the expression evaluates to True, the row in A
will be updated. See below.

A B C D E
1| 9 2 3 =IF(E1 = 1,B1 + C1,)
2| 7 2 3 =IF(E2 = 1,B2 + C2,) 1

Yes, I should have said that from the start, but...

Dave,



Select D1 then Edit > Copy
Select A1 then Edit Paste Special and check value.
 
Top