I am attempting to set up a spreadsheet that shows compounded interest. How do I copy one cell into the next without changing one of the paramaters? For example: =(a1*.4%)+b1 copied so the next cell (down one) reads =(a2*4%)+b1 =(a3*4%)+b1 etc.. I need the b1 to stay the same. I can go back and change it manually, but after you do that 360+ times, it gets rather old quickly. Any suggestions?
2007-02-28 06:42:55 · 3 answers · asked by pcnut4u 2 in Computers & Internet ➔ Programming & Design
Sorry Kenny, that didn't fix my problem.
2007-02-28 07:16:54 · update #1
Plez, the value of B1 will change. I've been doing it your way, but now I'm looking for a easier format. I would like to change the value of B1 and have it change the entire form. The form is for a 30 year, month by month chart. Changing B1 360 times takes a lot of work.
2007-02-28 08:20:28 · update #2
Use an absolute reference,
$B$1
,so that your worksheet function looks like this.
=(A1*.4%)+$B$1
.
2007-02-28 08:59:35 · answer #1 · answered by Kookiemon 6 · 0⤊ 0⤋
You can edit the cell by hitting F2. Then put the cursor on the variable you want to remain constant and hit F4. You will notice that the variable will change each time you hit F4. Continue hitting F4 until the variable is set to the specific cell you want. You may need to do this to the other variables so that they will change with the different cells as you copy the formula.
2007-02-28 14:51:19 · answer #2 · answered by Kenny 3 · 0⤊ 0⤋
if B1 is a constant why not just put it in the formula?
=(a1 * .4%) + 6% (or whatever it is a constant for)
2007-02-28 15:24:50 · answer #3 · answered by rod 6 · 0⤊ 0⤋