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
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