Percentage return value #DIV/0! - HELP!

This sounds silly but I dont know how to get rid of this error

I have to calculate the growth percentage

Growth % = (B/A)-1

A	B		Growth Percentage
2	5	=	150%
0	0	=	#DIV/0!
0	3	=	#DIV/0!
3	0	=	-100%

In example 2, the return value should be 0%
and in example 3, the return value should be 100%

Hope someone could help me. Appreciate it big time!
Thanks,
Rhea

And what should be result for A=5 and B=2?

If A=5, B=2 result should be -60%

Then why is A=3, B=0 +100 and not -100?
Since A=100 and B=1 would return -99%?

Actually allway when A>B should return negative (like 3>0):

Try this:

Formula:

Please Login or Register  to view this content.

Example:
The grocery shop had no sale yesterday but made $5 today. So there's a 100% growth in sales compared to previous day.

A/B-1=Growth

0/5-1=100% (I was required to show that if A=0 and B=with value, result should show 100%)

Try this:

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

and format as %

Brilliant!!!

I changed from

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

to

=IF(A1=0,--(B1>0), B1/A1-1)

Thank you sooo much!!! The formula really works!!!! You're a genius!!!!

by the way Zbor

what is the meaning of two negatives in your formula =IF(A1=0,--(B1=0), B1/A1-1) ???

Rhea

My mistake.. Changed