Information transfere from one cell to another cell in the same sheet with multiple formulas

Question

I am trying to send data from on cell to another in the same sheet. The cell I'm trying to send the data from is a result from a formula =VALUE(C11+E11) and that result and formula is in F11, and I am trying to send that result to C12. So, what formula second would I need to add to F11 to send the result to C12, and what term would I need in between the two formulas, or do I even need one?

Thanks for any help.

hansvogelaar · Answer

tdnile&nbsp;
In C12:
=F11

tdnile · Answer

I cannot do that because I need to use C12 as a cell that can be use for other adjustments in the future. I need to send the result from F11. So, I thought I could have a second formula in F11 to achieve the result needed. And, if that's possible what connector would I need between the two formulas, or do I need one?

randy birch · Answer

A cell formula cannot be used to directly set the value in another cell. You can react to changes seen in other cells, but not write the contents of another cell.

hansvogelaar · Answer

tdnile&nbsp;
In addition to the reply by Randy Birch, you cannot have two different formulas in one cell.

randy birch · Answer

Well ... technically you could. Consider this in cell B1 and what happens when nothing, or an A or B is entered into A1 where data exists in H, in this example:=SWITCH(A1,"A",SUM(H1:H16),"B",COUNTA(H1:H16),,"nothing to do")&nbsp;&nbsp;... or if you wanted to use a data validation list to give the user an easier experience ...&nbsp;=SWITCH(A3, "Sum H", SUM(H1:H16), "Count H", COUNTA(H1:H16),, "nothing to do")

Forum Discussion

Information transfere from one cell to another cell in the same sheet with multiple formulas

6 Replies

Resources