excel formula to calculate increase, decrease and 0 percentage

[mhtran1]

A	B	C
0	1874.35	100%
1874.35	0	-100%
0	0	0% (not #DIV/0!)
5672.66	561.77	-11%

<tbody>
</tbody>

Hello, I am trying to figure out a nested formula to calculate difference in percentage between two values and to not show #DIV/0!. Please help.

Thank you!

 

[arthurbr]

Try the IFERROR function (or IF(ISERROR.. on post 2007 versions)

 

[mhtran1]

Thank you arthurbr, but I tried the if(iserror((b2-a2)/b2),0,((b2-a2)/b2)) but result is 0 % instead of -100%. any other suggestions would be greatly appreciated.

 

[mhtran1]

THank you so much Arthurbr. Im not great in excel so any suggestions would be great!!

 

[arthurbr]

Perhaps =if(iserror((b2-a2)/b2),"",((b2-a2)/b2))