Excel 2002 Copying Exact formulas
 

Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another, the
column and row destinations are changing in the formula, with a result of 0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

Hi

if you use absolute referencing the formula should not change, e.g. use
=SUM($A$1:$A$100)
instead of
=SUM(A1:A100)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Kinjalip" wrote in message
...
Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another,
the
column and row destinations are changing in the formula, with a result of
0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

Hi
You'll need to make the references absolute. So instead of
=A2+A3
use
=$A$2+$A$3
This means that when the formula is copied and pasted, the reference to the
original cells remains.

--
Andy.


"Kinjalip" wrote in message
...
Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another,
the
column and row destinations are changing in the formula, with a result of
0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

If you only have one formula to copy|paste, then copy from the formula bar and
paste into the formula bar.

If you have lots, you can change the formulas to text:
edit|replace
what: =
with: $$$$$= (some unique string)
replace all

copy|paste normally

edit|replace
what: $$$$$=
with: =
replace all
(both in the source and destination ranges)

Kinjalip wrote:

Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another, the
column and row destinations are changing in the formula, with a result of 0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

--

Dave Peterson

When copying from the formula bar, don't forget to hit <Enter or <Esc
before pasting to the new cell.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Dave Peterson" wrote in message
...
If you only have one formula to copy|paste, then copy from the formula bar
and
paste into the formula bar.

If you have lots, you can change the formulas to text:
edit|replace
what: =
with: $$$$$= (some unique string)
replace all

copy|paste normally

edit|replace
what: $$$$$=
with: =
replace all
(both in the source and destination ranges)

Kinjalip wrote:

Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another,
the
column and row destinations are changing in the formula, with a result of
0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified

--

Dave Peterson