Did you really try it?

With the formula I gave you (adapted for using (A2-B2) rather than just
A2, which you didn't include in your original post):

=IF(B2=0,SIGN(A2),(A2-B2)/B2)

*does* return 100% when B2=0, not 0%.

The only way the formula can return 0% is if A2=B2.


In article ,
"sony654" wrote:

Thanks JE, but this returned 0%, for example: (10-8)/8 = 25%,

(a2-b2)/b2 = 25%
if b2 would = 0, i want the result to be 100%