| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I output result of formula to another cell?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I output result of formula to another cell?
Formulas can't do that. They can return values to the cell that holds them.
Francois wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I output result of formula to another cell?
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 "Francois" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I output result of formula to another cell?
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. Dave Peterson wrote: Formulas can't do that. They can return values to the cell that holds them. Francois wrote: 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. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell shows formula eg ='Sheet21'!F3 instead of result | Excel Worksheet Functions | |||
| Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
| Formula displays result in formula box but not in cell | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
