Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
There is an array formula which I tried to replicate but have problem.
I have a series of monthly returns in % and would like to multiply by 0.5 instead of adding 1 to the array range T11:T32.
But the result is always -1.
Is it possible to use multiplication or division in such array function ?
Cell V11 : { =PRODUCT(1+T11:T32)-1}
Thanks Read More