Forum Discussion
Information transfere from one cell to another cell in the same sheet with multiple formulas
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 a...
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?
In addition to the reply by Randy Birch, you cannot have two different formulas in one cell.
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")... or if you wanted to use a data validation list to give the user an easier experience ...
=SWITCH(A3, "Sum H", SUM(H1:H16), "Count H", COUNTA(H1:H16),, "nothing to do")
OK, in that sense, agreed.
