IFERROR with zero denominator

[shellwig]

Hello - I cannot get my formula to work with a zero as the denominator for all calculations. It works for majority but not all. My criteria is as follows:

A B Result
1092 329 232%
376 448 -16%
0 0 N/A
212 0 result should be 100% but formula produces N/A

Formula is IFERROR((A2-B2)/B2,"N/A")

I feel like I need another IF Statement for B2 but cannot get the formula to work. All suggestions welcome.

 

[Joe4]

212 0 result should be 100% but formula produces N/A

Why would that return 100%?
If the "A" value is 212 and the "B" value is 0, then you are trying to divide by 0, which gives you an error, which means the "N/A" value will be returned.

 

[shellwig]

I should have been more clear. I need my result to be 100%. The zero represents activity in that particular year. My result needs to be 100% since my problem represents year over year growth. Let's say Column A represents 2018 activity and Column B represents 2017 activity.

 

[vicx2ww]

jjust add a IF statment
=if(or(b2=0, b2<0),"100%",IFERROR((A2-B2)/B2,"N/A"))

 

[shellwig]

Perfect! Thank you very much!