This would give you the result you want:

C1 =IF(B1=0, A1, A1/B1-1)

formatted as a percentage, but that makes zero sense mathematically.

For instance

A B C
1 4 0.00 400%
2 4 0.01 39900%
3 4 0.80 400%

So your resulting "increase" would be 400% if you started at 0 or 0.80.
How would you tell the difference?





In article ,
Leland7 wrote:

I am doing comparison figures to determine percent of change. Some figures
compare for example 4 to 0 and instead of getting an increase of 400%, get
#DIV/0! .... anyone know a formula that would give me the right percent?