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
797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!