On Apr 9, 4:38 pm, JN wrote:
I'm sorry, I wasn't being very clear. I need 1 formula that would cover all
3 scenarios -
1) if Col B & C are equal, then return 0

No, my mistake. Your examples were quite clear. I overlooked this
case. Try the following:

=if(B1=0, if(C1=0, 0%, 100%), C1/B1 - 1)

Again, format as Percentage with the desired number of decimal places.

3) ABS value of Col B & Col C

This requirement does not make sense to me; and it does not seem to
jibe with any of your examples. I wonder if it is simply an over-
specification.

Or are you trying to cover cases where either B or C, or where both B
and C, are negative?

If so, please provide examples with the percentage change that you
would like to see.