Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMMATION combined with PV formula
turjes wrote:
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! Not sure, but would this work? start (s) = 6, end (e) = 12 = (FV*((r + 1)^(1 - s) - (r + 1)^(-e)))/r Dana DeLouis |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMMATION combined with PV formula
"Dana DeLouis" wrote: turjes wrote: 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! Not sure, but would this work? start (s) = 6, end (e) = 12 = (FV*((r + 1)^(1 - s) - (r + 1)^(-e)))/r Dana DeLouis Hi Dana, thank you for your response. I have a question though. How would I enter that in Excel? I'm confused about how to enter the "start (s) = 6, end (e) = 12" command. If you could please provide me with step-by-step instructions, I would really appreciate it. Thank you again for your help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMMATION combined with PV formula
Are you trying to do this summation with one function? That's going to be
most difficult. The most common way people would solve this problem is: 1. Enter FV and r in, say, a1 and a2 2. Enter the numbers 6 to 12 in, say, b1:b7 3. In c1, enter =$a$1/(1+$a$2)^b1 4. Copy c1 down to c7. 5. In c8, enter =sum(c1:c7) In less than a minute, you're done. Regards, Fred. "turjes" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I ENTER DATA WHEN I SEEM TO BE STUCK IN A SUMMATION FORMULA | New Users to Excel | |||
Combined formula | Excel Discussion (Misc queries) | |||
Combined formula | Excel Discussion (Misc queries) | |||
Summation Formula Needed | Excel Worksheet Functions | |||
How to od a combined IF and AND in a matrix formula | Excel Worksheet Functions |