I am making a chart and found part of my solution in a previous post. I used
the following formula to solve part of my dilema.

Q:
I have A1 and B1. How do I show the difference as a percentage in C1?
A:
As a percentage of A1: =(B1-A1)/A1, Format as %
As a percentage of B1: =(B1-A1)/B1, Format as %

My problem lies here. If A1 =0, then I get #DIV/0!. If both A1 and B1 are =0
I get the same message.

I am trying to show the number of cases compared as a + or - percentage
between A1 and B1, as in the number increased by a certain percentage.

EX:
A1=5
B1=1
Answer= +80%

I also need the formula to show as a negative percentage, as in the number
decreased a certain percentage.