#DIV/0! error

[ApolloID]

Hi, i have this three situations:

A..................B.................C
355,626 54,882 -85%
0 20,662 #DIV/0!
-111,43 0 100%

In C i have this formula: =(B10-A10)/ABS(A10)
This formula calculates the diference between B1 and A1 as percentage.

I need a formula to give me the correct result in all three situations.
The first situation is correct. I need the formula for the last too.

Can this be done?
Thanks!

 

[ApolloID]

It's good.
I have a last problem. At least i hope so..
If i have this:
-15 0
the result is #DIV/0!

 

[milesUK]

Again, what answer do you want from this? bosco_yip's formula

=IF(B1=0,0,(B1-A1)/MAX(A1,B1))

will capture this and return zero. But I would modify it again to cater for -ve values in column B

=IF(B1=0,0,(B1-A1)/MAX((ABS(A1),ABS(B1)))

or my original

=(B1-A1)/MAX(ABS(A1),ABS(B1))

and possibly also

=ABS((B1-A1)/MAX(ABS(A1),ABS(B1)))

to return all results as +ve values.

 

[ApolloID]

Now everything it's ok.
Thanks you all for everything!!!
Thanks!