LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I ENTER DATA WHEN I SEEM TO BE STUCK IN A SUMMATION FORMULA kenneth j peterson New Users to Excel 4 January 12th 09 05:48 PM
Combined formula Simon Minder[_2_] Excel Discussion (Misc queries) 6 October 23rd 08 05:06 PM
Combined formula Pete_UK Excel Discussion (Misc queries) 0 October 23rd 08 03:50 PM
Summation Formula Needed addie Excel Worksheet Functions 6 February 18th 06 08:12 AM
How to od a combined IF and AND in a matrix formula murphyfilur Excel Worksheet Functions 3 May 28th 05 12:36 PM


All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"