View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
turjes turjes is offline
external usenet poster
 
Posts: 2
Default SUMMATION combined with PV formula

Greetings,

I am using EXCEL 2008 on a MAC. I am trying to use the Present Value formula
in a summation formula. The problem is that I don't see a SUMMATION formula
(the uppercase SIGMA sign) anywhere, I even tried looking it up.

My PV function would look like this:

PV = FV/(1+r)^i

With the summation formula being utilized with that, I want it to sum up the
PV going from i=6 to i=12. Is there any way to do that in Excel? Any help
would be appreciated, thank you!