Excel - send result of formula to another cel [Closed]

Report
-
 Penguin Duvel -
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.

5 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
the question is not clear
if in any cell if you type A1+B1 it will give that result.

more clarification is required.
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month


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!
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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?
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.
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.
Hi Sim,

What do you want the formula to do?
Can you clearify what you are wondering about?

Best regards,
Trowa