Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula results to be copied into a different cell
Hello,
I would like a solution to my problem. I have a formula with a result in "G1". How can I bring over the result into cell "B1"? Once I closed out of the lookup sheet and went back to my original sheet witth the formula results I did copy on "G1" and tried to paste it to "A1" but all I am getting is "REF". Please answer. Thank you -- smile |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula results to be copied into a different cell
"israel" wrote in message
... Hello, I would like a solution to my problem. I have a formula with a result in "G1". How can I bring over the result into cell "B1"? Once I closed out of the lookup sheet and went back to my original sheet witth the formula results I did copy on "G1" and tried to paste it to "A1" but all I am getting is "REF". Please answer. Thank you -- smile You need to edit the formula before you copy it (I assume that's what you want to do) so that all the cell references are absolute. Example: $B$1*$C$1 is a formula with absolute cell references in it. -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula results to be copied into a different cell
In B1 enter =G1
Or copy G1 and select B1 to paste specialvalues Gord Dibben MS Excel MVP On Wed, 29 Apr 2009 21:06:56 +0100, "Gordon" wrote: "israel" wrote in message ... Hello, I would like a solution to my problem. I have a formula with a result in "G1". How can I bring over the result into cell "B1"? Once I closed out of the lookup sheet and went back to my original sheet witth the formula results I did copy on "G1" and tried to paste it to "A1" but all I am getting is "REF". Please answer. Thank you -- smile You need to edit the formula before you copy it (I assume that's what you want to do) so that all the cell references are absolute. Example: $B$1*$C$1 is a formula with absolute cell references in it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
Formula when copied into a new cell doesn't recalculate | Excel Discussion (Misc queries) | |||
Unwanted formula being copied to cell | Excel Discussion (Misc queries) | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
I get a 0 value when a formula is copied to another cell | Excel Discussion (Misc queries) |