Thread: Need an Excel formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Need an Excel formula
=A2*(1+6%)^B2
--
David Biddulph

"Paul G" <Paul wrote in message
...
I need an excel formula that will calculate the total sum of a number when
escalated by a fixed percentage rate over a variable number of years.
My
variables would be the initial cost and the number of years. the fixed
number would be the 6% increase compounded each year. Can you help?


Reply With QuoteReply With Quote