Performance acheivement & growth

[komsorn]

I'm komsorn
i have problem about acheived and growth.

thank you.

 

[Hui]

Komsorn

Firstly, welcome to the Chandoo.org Forums

As you know you cannot divide by zero
Ideally where you are dividing by zero there should be infinite Growth
However a better technique is to reset that to either 0 or 100%

for 0%
C2: =IFERROR(B2/A2,0)
D2: =IFERROR((B2-A2)/A2,0)
Copy both down

or for 100%
C2: =IFERROR(B2/A2,1)
D2: =IFERROR((B2-A2)/A2,1)
Copy both down