Search : in
By :

Excel - send result of formula to another cel

Last answer on Nov 11, 2009 3:19:59 pm GMT Ajay, on Oct 22, 2009 3:19:59 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP
Firefox 3.5.3

Best answers for « excel send result of formula to another cel » in :
[Excel]changing cell formula to text Show [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
EXCEL: Nested IF formula question (Solved) Show
Excel - Send value of cell to target Show Excel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Manipulating Excel comments ShowManipulating Excel comments Associating an explanatory comment to a cell Customizing the format of this comment Associating an explanatory comment to a cell Put your cursor on cell you want to comment. Right-click the cell, then...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

venkat1926, on Oct 23, 2009 3:20:32 am BST

The question is not clear
if in any cell if you type A1+B1 it will give that result.

more clarification is required.

   
Reply to venkat1926

2

Trowa, on Oct 23, 2009 11:32:29 am BST

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?

   
Reply to Trowa

3

sim, on Oct 29, 2009 8:35:12 pm GMT

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.

   
Reply to sim

4

sim, on Oct 29, 2009 8:35:18 pm GMT

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.

   
Reply to sim

7

Trowa, on Oct 30, 2009 12:49:10 pm GMT

Hi Sim,

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

Best regards,
Trowa

   
Reply to Trowa

8

 Penguin Duvel, on Nov 11, 2009 3:19:59 pm GMT

Try this dodge, it works for me...

http://www.ozgrid.com/Excel/convert-excel-formulas-values.ht­m

And, salutes to whoever put it in there!

   
Reply to Penguin Duvel
Ask your question Reply
They need your help