formula problem

[Bob Ziemke]

On my spreadsheet I have a formula for column c where column d is multiplied by a number and it auto updates the value to column c. It is working fine. However I need to add more columns on my sheet. I have tried to highlight, copy, paste, etc., but cannot get the formula to continue further down the page. can someone help me out? I am sure it is very simple to do as I set the spreadsheet up in Jan of this year and cannot for the life of me remember how to do this one step. Thanks in advance.

 

[Excelsiordave]

Post your formula in column D and I'll have a look....

Cheers,

Dave.

 

[Bob Ziemke]

=+D9*0.002228, I ended the column at 225 and need to continue it thru 240.

 

[Excelsiordave]

It should work but will depend on the context, as a matter of interest do you have auto calculate switched on as a first check. (Not trying to teach you how to suck eggs!!)

Also, are you copying the formula down or across?

 

[Bob Ziemke]

I'll check to see if auto complete is on. I am copying down.