Excel Question!

[almo136]

I am trying to write an excel formula and then use the fill down option to replicate it for other cells.

The thing is I don't want all the cells within the formula to use the values in the cell below. There are some cells in the formula which i want to remain the same when filled down. How can I add this into the formula so it doesn't automatically edit the formula.

sorry i didn't know how to write this in a less confusing way.

hopefully someone understands!!!

[HelenaP]

I am trying to write an excel formula and then use the fill down option to replicate it for other cells.

The thing is I don't want all the cells within the formula to use the values in the cell below. There are some cells in the formula which i want to remain the same when filled down. How can I add this into the formula so it doesn't automatically edit the formula.

sorry i didn't know how to write this in a less confusing way.

hopefully someone understands!!!


I simply loathe Excel, but I am sure someone here will be able to help if you hang tight!
Good luck!

[Lord_of_the_Dense]

How many cells are you talking total and are you going to add more later? Post an example of the formula and indicate the portions which you wish to increase vs. the ones you wish to remain unchanged. I assume there will be several (dozens +) cells to do or else it might just be easier to enter each formula individually. If you want, you can send the file (unless they're pornographic numbers or bank accounts) to me and I can mess with it unless someone else has an immediate solution.

[wingnut2600]

Well... Your question is vague for what you want to do, but here is one way...

1) write a formula...
2) either copy it or drag it down using the right-hand corner to replicate it in a manner that copies the dynamic cell reference.
3) for cells you don't want to change, add a $ sign in front of the cell reference (before the letter if only column-static or before the number if row-static).
4) copy the changed static-cell formula into the cells you wish to stay the same.
5) you could also delete the formula in cells that you want to stay the same.

I have no level of your spreadsheet familiarity, so I am not sure how complicated that you really need. My suggestion is to search Google (there are a shitload of Excel resources) or re-post your inquiry saying what you need done, dataset, etc.

[enter8]

Wingnut is correct, just think of the dollar sign as a way of telling the program to never change the value when you autofill. If, for instance, you have a formula referencing cell A1, if you change it to $A$1 any autofills you do will always reference that cell.

[wingnut2600]

I simply loathe Excel, but I am sure someone here will be able to help if you hang tight!
Good luck!

Don't be a hater... Excel is one of the few truly good things in the universe. In fact, I bet it is the one software program that has platform-independent love. Excel does what it does very well.

Wingnut <3 Excel

[almo136]

thanks everyone!! the $ sign worked a treat!

[SeaPlankton]

It's the difference between absolute and relative addressing, which no-one has mentioned, but I never use it.

[SeaPlankton]

It's a little American-ised and predjudice if you ask me. "$" < this for example is a filthy symbol of RIAA pressure on the CRIAA who in turn closed Demonoid, who are in fact "very wholesome" (para. see comments on main news page). The correct symbol should be : * < a symbol for which the debate can be long and heated - is it an asterix? is it a star? is it a flower? Who knows, but it had to be said. :P

[SeaPlankton]

Who buys Celine Dion anyway? J'aime votre corps et vos jambes. Vache sale.

[moon light]

i hate it it's difficult

[ratcat]

Don't be a hater... Excel is one of the few truly good things in the universe. In fact, I bet it is the one software program that has platform-independent love. Excel does what it does very well.

Wingnut <3 Excel
Back in the early 90's I did a small course on windows works and all i was worried about was word. Didn't care about excel side of things (under my breathe "what do I need this shit for")

Guess what?? (15 years later had to relearn it) The damme thing is a big part my working life and l loving it.