Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no formula results in cell | Excel Worksheet Functions | |||
Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) | |||
VLOOKUP - results do not appear in cell | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |