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!!!
Originally Posted by almo136
I simply loathe Excel, but I am sure someone here will be able to help if you hang tight!
Good luck!
The most Beautiful thing we can experience is the mysterious.
It is the source of all true art and science.
~ Albert E.
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.
17 USC § 1008 Prohibition on certain infringement actions:
No action may be brought under this title alleging infringement of copyright based on the noncommercial use by a consumer for making digital musical or analog musical recordings.
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.
"There's a passage I got memorized. Ezekiel 25:17... I been sayin' that shit for years. And if you ever heard it, it meant your ass. I never really questioned what it meant. I thought it was just a cold-blooded thing to say to a motherfucker before you popped a cap in his ass. But I saw some shit this mornin' made me think twice… The truth is you're the weak. And I'm the tyranny of evil men. But I'm tryin', Ringo. I'm tryin' real hard to be a shepherd."
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.
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
"There's a passage I got memorized. Ezekiel 25:17... I been sayin' that shit for years. And if you ever heard it, it meant your ass. I never really questioned what it meant. I thought it was just a cold-blooded thing to say to a motherfucker before you popped a cap in his ass. But I saw some shit this mornin' made me think twice… The truth is you're the weak. And I'm the tyranny of evil men. But I'm tryin', Ringo. I'm tryin' real hard to be a shepherd."
thanks everyone!! the $ sign worked a treat!
It's the difference between absolute and relative addressing, which no-one has mentioned, but I never use it.
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
Who buys Celine Dion anyway? J'aime votre corps et vos jambes. Vache sale.
i hate it it's difficult
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.
Posting Permissions
Bookmarks