MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Any idea what's wrong with this Formula????


Posted by Lina on October 30, 2001 7:01 AM

Hi,
I posted the following question a few days ago:

'How can I find out the average percentage changes (either increase or decrease) e.g the average % changes between A1 and A10? Thanks for reading'.

I got this answer
in whatever cell you want the result to show type:
=round(sum((a1/a10)-100%,3)
this will show the pct of change that A1 is from A10 rounded off to three places.

I tried this formula,but I got an message saying my formula was missing a parenthesis. Any ideas? Thanks.


Posted by conor on October 30, 2001 7:07 AM


you have three brackets open but only two closed, hence u need to put another ")" in at the end

Posted by eddie g on October 30, 2001 7:14 AM

=round(sum((a1/a10)-100%,3))

Posted by Juan Pablo on October 30, 2001 8:06 AM

Should be =ROUND(SUM(A1/A10-100%),3) or =ROUND(SUM((A1/A10)-100%),3)

Posted by Juan Pablo on October 30, 2001 8:07 AM

In fact, you could have =ROUND(A1/A10-1,3)

Posted by Lina on October 30, 2001 1:10 PM

Thanks!!! :)