I have a spreadsheet with columns numbered 1,2,3,...,n and rows numbered 1,2,3,...,k. I want for the entry in the kth rown and nth column to be the following formula:

k*(25822(1.05)^n-813n-25822)

My primary question is how do I do this. But messing around trying to get it to work has raised a few questions about how Excel works. Most specifically, why when I write the formula =A2*(25822(1.05)^(B1)-813(B1)-25822) and then try to "drag" it to other cells, does A2 change to A3, A4, A5, etc (as I would like it to) but B1 remains fixed at B1 (as I wouldn't like it to)?

For clarity:
A2=1, A3=2, A4=3...
B1=1, B2=2, B3=3... (which is why I'd prefer Bi to become B(i+1) when I "drag"

It looks like you want k*25822*1.05^ (n-813n-25822) right? In that case, you would need an extra pair of parenthesis in your formula.

Make sure there are no $ symbols in the formula you have in excel. $ means fixed position. For example, $B$1 indicates a fixed position and thus will never be incremented to B2, B3, etc.

I'm actually trying to get

k*[ (25822)*(1.05)^(n)-(813*n)-(25822.8) ]

Using $ can also fix a single row or column....$b1 b$1 $b$1.


Also try here http://forumserver.twoplustwo.com/34...-excel-874910/

=$A2*(25822*(1.05)^(B$1)-813*(B$1)-25822)