I have a couple of decades worth of monthly returns that I need to compound for total returns after certain periods of time including total (not annual). I have tried using the following formula but it has returned a #VALUE error:
=PRODUCT(1+J4:J300)^(1/297)-1
If I remove the first '1' a number is computed; however this does not give me the appropriate calculation. I am wondering if the issue is being caused by a cell that is text but I have made every attempt to make sure all of my data is formatted as numbers.
Also, I have tried moving around my parentheses, as well as trying 'Control + Shift + Enter.'
Bookmarks