View Single Post
  #1   Report Post  
Dave Boland
 
Posts: n/a
Default How to refer the results of one cell to another cell?

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