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

- - Latest reply:  Penguin Duvel - Nov 11, 2009 at 10:19 AM
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.
See more 

5 replies

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

more clarification is required.

Say "Thank you" 2

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

CCM 5984 users have said thank you to us this month

2
Thank you
Try this dodge, it works for me...

http://www.ozgrid.com/Excel/convert-excel-formulas-values.htm

And, salutes to whoever put it in there!

Say "Thank you" 2

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

CCM 5984 users have said thank you to us this month

0
Thank you
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?
0
Thank you
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.
0
Thank you
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