how do I output result of formula to another cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to output the result of a formula to another cell (say formula
in a1 and result of a1's formula in a2)
I do not want a formula in a2, it must remain a completely blank cell, until
the value of the formula in a1 is sent to a2.
 
Formulas can't do that. They can return values to the cell that holds them.
 
Francois -

Copy A1 and go to Edit / Paste Special. Under the paste options there is one
to paste only the value (and not the formula) hope this helps!

Tonya
 
If by "completely blank", you meant that the cell had to look empty...

You could use a formula in A2:

=if(somethingistrue,yourformula,"")

the "" will make the cell look blank--but the cell won't be empty--it'll contain
the formula.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Impacting a cell 4
Continuous Invoice Nos. 3
Combining Formula's 5
Combining Text From Cells 3
How do I make this work? 15
Formula with Cell reference to include formating? 13
copy and paste the cell with formula ="1" 3

Back
Top