Hi,
I use the following array function to compound a time series of monthly growth rates:
{=(PRODUCT(1+A1:A10/100)-1)*100}
Is it possible to replace this with one of the new Dynamic Array functions?
Thanks!
Hi,
I use the following array function to compound a time series of monthly growth rates:
{=(PRODUCT(1+A1:A10/100)-1)*100}
Is it possible to replace this with one of the new Dynamic Array functions?
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks