=100000*(1+6%)^ROW(A1) in your first row will give the answer for 1 year.
Copy down as far as necessary.
--
David Biddulph

"Rene" wrote in message
...
What is the function I use for showing me how much a fixed 6% annually
will
yield over the years. For instance, on $100,000 the first year would
yield
$106,000, the second year, how much, the fifth year, tenth, etc.
--
Rene - Do appreciate your help. I have had simply the best help with
these
groups, and it's where I turn to for serious help.