Claculating % change with three conditions

[aara]

HI,

I tried to use formulas for similar tasks already posted in this forum, but I did not work. Here is my situation:

I have two columns with values for two periods. Let’s say it is library enrollment per county for the year 2017 and year 2016. I need to calculate percent change. Sounds simple. But for both 2017 and 2016 there are counties that had 0 enrollees. If this happened in 2017, then I can use iferror formula and add -100%. If number of enrollees was 0 in 2016, then I can add 100%. If number of enrollees was the same in 2017 and 2016, that’s 0% percent change. But I do not know how to nest all three conditions in one formula. I keep getting either "too many arguments" or #DIV, or incorrect values because one of these conditions did not work. Can anyone help please???

Simplified table looks like this:
COL A COL B COL C COL D
2017 Enrollees 2016 Enrollees % Change
Cty A 56 15
Cty B 12 0
Cty C 25 25
Cty D 0 69
Cty E 0 0

Thanks so much!!!

[dosydos]

assuming your 2017 data starts in cell A2 and your 2016 data starts in B2, then use this formula:

Please Login or Register  to view this content.

[aara]

This works, yeeey! Thanks so much!!!