Use the future value function:

FV(rate,nper,pmt,pv,type)

the description in Excel Help is quite good.
--
Gary''s Student - gsnu200713


"jeffw01" wrote:

I need the formula for future value. Investing $100 per pay period (26 pay
periods per year) over the next 30 years at a 7% interest rate compounded
monthly.
Thank you