Formula Replication

[Guest]

I am trying to replicate a formula down a Column and all I get is an
exact(absolute) copy.

I have tried to use the "Drag Handle" and the
"Highlight-Edit-Copy-Drag/Highlight-Paste" functions but All I get is a
"Copy" with no updating of the "Row" information.

Any suggestions along this line would be helpful.

Thanks in advance,

Fred

PS: I am using Xcel 2003

 

[RagDyeR]

Post the exact formula.


--

Regards,

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

I am trying to replicate a formula down a Column and all I get is an
exact(absolute) copy.

I have tried to use the "Drag Handle" and the
"Highlight-Edit-Copy-Drag/Highlight-Paste" functions but All I get is a
"Copy" with no updating of the "Row" information.

Any suggestions along this line would be helpful.

Thanks in advance,

Fred

PS: I am using Xcel 2003

 

[Guest]

Is your calculation set to manual? Tools/Options/Calculation - change to
automatic.

Or, you could be using absolute references ($A$1 or A$1) instead of relative
references (A1).

 

[Don Guillett]

Do you have calculation set to automatic?
Have you removed the absolute references $$$$$

 

[Guest]

Thank all three of you for answering.

Calculation ISWAS set to Automatic.
Am not using "Absolute" symbolization (like R5C3, NOT $R$5)

Example: If I have this equation in R5C4,
=IF(SUM(R5C1:R5C3)="","",SUM(R5C1:R5C3))

If I try to replicate/drag that equation down the Column4 to rows 6 thru
12, "R5" stays and does not change to R6, R7, R8.....

Could there be something in the "Lock" features of XCELL that I should check??

Again, thanks for your answers,

Fred

 

[Don Guillett]

Change from r1c1 style and you will see that you are in absolutes.

 

[David Biddulph]

You need to look at the difference between absolute and relative references.
You've got absolute addresses, as Don suggested.

If you're using R1C1 cell references, then if you go into your formula bar
and while in your formula select the range R5C1:R5C3, it will, by default,
show as RC[-3]:RC[-1], so your formula will become
=IF(SUM(RC[-3]:RC[-1])="","",SUM(RC[-3]:RC[-1])) {which are relative
references, the equivalent of the cell reference defaulting to not having
the $ for an absolute reference in the A1 style}and hence if you drag down
it will continue to refer to RC[-3]:RC[-1].

As when using the A1 reference style, if, in the formula bar, you select a
cell reference, f4 will toggle between the various absolute and relative
references.

 

[Guest]

Thanks Don,

I really don't understand what you just told me. How would you write that
equation or change to what style??

Fred

 

[David Biddulph]

Tools/ Options/ Genera/ Uncheck R1C1 reference style.
Then, if you still don't understand, look at help for absolute and relative
cell references.