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 |
How to refer the results of one cell to another cell?
Select D1 then Edit Copy
Select A1 then Edit Paste Special and check value. -- Gary's Student "Dave Boland" wrote: 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 |
How to refer the results of one cell to another cell?
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. -- Gary's Student "Dave Boland" wrote: 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 |
All times are GMT +1. The time now is 09:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com