growth function

%3CLINGO-SUB%20id%3D%22lingo-sub-1263053%22%20slang%3D%22en-US%22%3Egrowth%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1263053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20to%20calculate%20the%20growth%20of%20several%20variables%20for%20many%20years%20and%20sectors%2C%20how%20to%20use%20a%20growth%20function%20for%20a%20variable%20in%20several%20tables%3F%20I%20tried%2C%20but%20this%20is%20not%20efficient%20...%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E%3DCRESCIMENTO(%22%5BK3%3B'2008'!C5%3B'2007'!C2%3B'2006'!C2%3B'2005'!C2%3B'2004'!C2%3B'2003'!C2%3B'2002'!C2%3B'2001'!C2%3B'2000'!C2%3B'1999'!C2%3B'1998'!C2%3B'1997'!C2%3B'1996'!C2%3B'1995'!C2%5D%22)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3EI%20need%20help%20please!%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3EBest%2C%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1263053%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I need to calculate the growth of several variables for many years and sectors, how to use a growth function for a variable in several tables? I tried, but this is not efficient ...

=CRESCIMENTO("[K3;'2008'!C5;'2007'!C2;'2006'!C2;'2005'!C2;'2004'!C2;'2003'!C2;'2002'!C2;'2001'!C2;'2000'!C2;'1999'!C2;'1998'!C2;'1997'!C2;'1996'!C2;'1995'!C2]")

 

I need help please!

Best,

0 Replies