Create a condition within an IFERROR formula

[ACDC]

Hi All,

I'm creating a budget that looks similar to the following:
A B
1 - $0.00 $0.00
2 - $0.00 $100.00

I'm trying to calculate the % change between the 2 numbers, so for both rows (B-A/A)x100.
Naturally the DIV!/0 will pop up due to the 0 in column A and I could easily correct this with a quick IFERROR, but financially the % difference would actually be different between the two.

In the first row I'd like to show 0% change and the 2nd row show 100% change since column B would represent the new budget.

Is it possible to specify a condition within an IFERROR formula to specify "0%" and "100%"?
Here's what I have tried so far...
=IFERROR(((B1-A1)/A1), B1=0, B1>0,"0%","100%")
=IF((AND(B1=0, B1>0,"0%","100%"), IFERROR((B1-A1)/A1)

Thanks in advance everyone!

 

[sparky2205]

=IFERROR((B1-A1)/A1*100,B1)