Autofill declining reference.

[George Wilson]

I am currently using Excel XP on a Windows 2000 system. I
am trying to do an auto fill of a decling refference with
increasing rows the cells should decrement by 2 as
follows: row 160 "=C33355", row 161 "=C33353", row
162 "=C33351" When I fill in a few of these and try to do
an autofill I get sequence that makes no sense. Am I
trying to do this the wrong way? Is there another option
to make the auto fill work properly?
TIA
George

 

[Frank Kabel]

Hi
enter the following in cell A160:
=OFFSET($C$33355,-(ROW()-1)*2),0)

 

[George Wilson]

I entered in this formula and get a "too few arguments"
error, What could I be doing wrong?
George

 

[Frank Kabel]

Hi
sorry, a typoe. Try:
=OFFSET($C$33355,-(ROW()-1)*2,0)

 

[George Wilson]

Thank you for your help Frank. This formula is not giving
me the error but the result seems to be subtracting
something from the original value. Can you think of any
reason it would do that?
TIA
George

 

[Frank Kabel]

Hi
it shouöd not subtract anything
It should get you the cell references you wanted:
C33355
C33353
C33351

What are your exact data and what is your result

 

[George Wilson]

=OFFSET($C$33355,-(ROW()-1)*2,0)is returning a value of
0.73
Cell c33355 has a value of 2.37, cell c33353 has a value
of 2.89. None of the cells anywhere around c33355 have a
value below 1. The value is not reflecting properly.
Thank you for your assistance,
George

 

[Frank Kabel]

Hi
I assumed you enter this formula in row 1. So try:
=OFFSET($C$33355,-(ROW(1:1)-1)*2,0)

 

[George Wilson]

That one works, thank you kindly Frank...
George

-----Original Message-----
Hi
I assumed you enter this formula in row 1. So try:
=OFFSET($C$33355,-(ROW(1:1)-1)*2,0)

--
Regards
Frank Kabel
Frankfurt, Germany




.