Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Weighted Return Function
I have a series of returns (%ages) in rows E1208:E1297 and am trying to link
them up to a time weighted return. The formula I'm trying to create is as follow: [(1+r1)*(1+r2)*(1+r3)*.....(1+rN)]-1. r1 = E1208 r2 = E1209 ....Etc until I get to E1297 Does someone know how I can do this with a formula? Please advise. Thanks in advance!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I freeze the time in the NOW() function? | Excel Worksheet Functions | |||
Hyperlink function without openening new Explorer every time | Excel Worksheet Functions | |||
Function to convert Time String to Time | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Function to Return another Worksheets Name | Excel Worksheet Functions |