A count rising from zero to five is a clear increase of five, but the usual percentage-change formula cannot express it as a finite percentage. The starting value deserves a check before the calculation.
Write out the denominator
The familiar calculation divides the difference by the starting value, then multiplies by one hundred. For zero to five, that would require dividing five by zero. Writing “a 500 percent increase” does not solve the problem.
Use a direct description instead: the count went from zero to five during the stated periods. If a reporting system uses a special convention, explain that convention rather than presenting it as the ordinary formula.
Keep zero separate from missing information
A recorded zero means the measured count was zero under the collection rules. An empty starting cell may mean no observation was available. Neither should silently become a convenient denominator.
When building a spreadsheet, give this case an explicit output such as “percentage change not defined.” Show the starting and ending counts alongside it. Readers still learn exactly what changed, while the table avoids a dramatic percentage that the underlying arithmetic cannot support.

