"reichertj" wrote apparently:
How do I calculate the future value of a series of annual deposits? I would
like to accomplish this with a single formula in a cell that references other
cells with the annual deposit amount, the interst rate and the number of years

Click on Help - Excel Help and search for the FV function. But a
concrete example might help.

If A1 is the annual deposit, A2 is the annual "interest rate", and A3
is the number of years, ostensibly you could do the following:

=fv(A2, A3, -A1, 0, 1)

That assumes that the "interest rate" is the APY, not the nominal
interest rate. If you have only nominal interest rate, the following
estimates the APY, assuming daily compounding:

fv(A2/365, 365, 0, -1) - 1

You could put that in place of "A2" in the first formula. But
arguably it is a nitpick. The difference is likely to be very small,
especially as a percentage of the total future value.