How to calculate % of growth for following employees

Example:  calculation of growth employee wise.

% of growth
Year of DOJ	person A	person B	person C	person D
2017-18	14000	16000	18000	30000
2016-17	10000	14000	16000	20000
2015-16	8000	12000	14000	15000
2014-15	6000	10000	12000
2013-14	0	8000	10000
2012-13	0		8000
2011-12	0		6000

Now you are easily calculate % of growth with nested IF formula in the Microsoft Excel

Formula For person A 

“=IF(B9>0,(B3:B9)/B9,IF(B8>0,(B3:B8)/B8,IF(B7>0,(B3:B7)/B7,IF(B6>0,(B3:B6)/B6,IF(B5>0,(B3:B5)/B5,IF(B4>0,(B3:B4)/B4))))))”

Result A: 233%

Formula For person B

“=IF(C9>0,(C3:C9)/C9,IF(C8>0,(C3:C8)/C8,IF(C7>0,(C3:C7)/C7,IF(C6>0,(C3:C6)/C6,IF(C5>0,(C3:C5)/C5,IF(C4>0,(C3:C4)/C4))))))”

Result B: 200%

Formula For person C

“=IF(D9>0,(D3:D9)/D9,IF(D8>0,(D3:D8)/D8,IF(D7>0,(D3:D7)/D7,IF(D6>0,(D3:D6)/D6,IF(D5>0,(D3:D5)/D5,IF(D4>0,(D3:D4)/D4))))))”

Result C: 300%

Formula For person D

“=IF(E9>0,(E3:E9)/E9,IF(E8>0,(E3:E8)/E8,IF(E7>0,(E3:E7)/E7,IF(E6>0,(E3:E6)/E6,IF(E5>0,(E3:E5)/E5,IF(E4>0,(E3:E4)/E4))))))”

Result D : 200%

% of growth	233%	200%	300%	200%
Year of DOJ	person A	person B	person C	person D
2017-18	14000	16000	18000	30000
2016-17	10000	14000	16000	20000
2015-16	8000	12000	14000	15000
2014-15	6000	10000	12000
2013-14	0	8000	10000
2012-13	0		8000
2011-12	0		6000