Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excell Question, Reference the cell above?
How do I reference the "cell above" another cell. Even if I insert a row?
I have tried the $ constant, but if I insert a row, I have to "fix" my reference.
Basically I have a home made budget in excel to track my account balance based on bills and outstanding checks, If I insert a new expense I have to "fix" it.
Yes I know quicken is better. But if I want to do things that don't make sense that is my business! :)
2 Answers
- phantasygirlhfcLv 61 decade agoFavorite Answer
it should be as simple as .. typing = in the cell you want to have the reference in and then click on the cell you want the reference to be (you can also add additional things like ..say you want your new cell to be 5 less than the cell referenced type = (then click your reference cell then -5) and press enter ..if you add rows it doesnt make a difference it still references the cell you clicked.
I hope this makes sense.
Source(s): PS if you need more help you can IM me on yahoo - 1 decade ago
just go B2 or what ever cell. dont use the $, then it will keep it on B2 always, even if a row is inserted.
for example.
=b2/5.
