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