excel formula to calculate increase, decrease and 0 percentage

[mhtran1]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]1874.35
[/TD]
[TD]100%
[/TD]
[/TR]
[TR]
[TD]1874.35
[/TD]
[TD]0
[/TD]
[TD]-100%
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0% (not #DIV/0!)
[/TD]
[/TR]
[TR]
[TD]5672.66
[/TD]
[TD]561.77
[/TD]
[TD]-11%
[/TD]
[/TR]
</tbody>[/TABLE]

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))