LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
no formula results in cell schuldies21 Excel Worksheet Functions 3 September 7th 05 08:20 AM
Search Range for Criteria in given cell and produce results RFreeman12 Excel Discussion (Misc queries) 3 June 27th 05 09:23 PM
VLOOKUP - results do not appear in cell denvertique Excel Worksheet Functions 1 April 22nd 05 11:41 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 08:39 PM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"