excel - send result of formula to another celClosed

Question

Hello,
Is it possible to have the results of a formula go to a cell other than the cell containing the formula?

And I don't want to do the '=c5' type thing. That's the wrong way round (that's another cell requsting the data from the forumla cell. I need the formula cell to pro-actively send the results to the other cell, so the other cell can contain the actual data)

This is so that if someone does ctrl-c on the cell and they copy the value rather than the formula.

venkat1926 · Accepted Answer

the question is not clear 
 if in any cell if you type A1+B1 it will give that result. 

more clarification is required.

Trowa · Answer

If it's just one or a few formula's:
Copy the cell containing the formula and paste special it to the destination cell selecting the option Value.

Does this help?

sim · Answer

I think what he/she is saying is something like this:

Example, a formula typed in cell B3

=if(A1=1,G6=A1+A4,G6)

I too, am wondering if there is a way to do that.

sim · Answer

I think what he/she is saying is something like this:

Example, a formula typed in cell B3

=if(A1=1,G6=A1+A4,G6)

I too, am wondering if there is a way to do that.

Penguin Duvel · Answer

Try this dodge, it works for me...

https://www.ozgrid.com/Excel/convert-excel-formulas-values.htm

And, salutes to whoever put it in there!

Excel - send result of formula to another cel

5 responses

Similar discussions

Subscribe To Our Newsletter!