On Oct 2, 9:04 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=100000*(1+6%)^ROW(A1) in your first row will give the answer for 1 year.
Copy down as far as necessary.

Or simply put 100000 into A1, =A1*(1+6%) in to A2, and copy down A2 as
needed.

Besides being more efficient, arguably it is less error-prone. With
"^row(A1)", move the table afterwards (other than left or right), and
everything is fubar. That might seem obvious to you. But if the OP
cannot figure out how to use FV based on Bernard's response, he/she
probably could not begin to fathom the chaos brought on by the misuse
of row(A1).