Using Growth On Disjoint Cells

J

Justin

Hi,
I'm trying to use GROWTH() on disjoint cells, so that I can just fill in the
values in the table (i.e. between years 2000 and 2005, for which I have
data). I want then, to use =GROWTH((B1,B6),(A1,A6),B2), thinking it will
take B1 and B6 as a series and A1 and A6 as a series, and give me the value
for 2001. However, Excel expands this to =GROWTH(B1,B6,A1,A6,B2) which of
course does not work. Is there any way to do this other than to copy the
projecting values to another part of the table?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top