Percentage Increase Without DIV/0 Error

[meppwc]

Looking for another way around the DIV/0 error on a formula that determines the percentage increase comparing 2 numbers.
The formula below which is in cell E8 works most of the time
=IF(B8=0,-"0%",(C8-B8)/B8)

B8: 1 (the value in B8 is "1" and is user entered)
C8: 2 (the value in C8 is "2" and is user entered)
D8: 1 (the value in this field is a formula "=C8-B8" and is referred to as "Difference"
E8: 100% (the value in this field is a formula "=IF(B8=0,-"0%",(C8-B8)/B8)" and is referred to as "% Difference"

This formula in E8 works correctly all of the time unless the value in B8 is zero.
If the value in B8 is zero, then the result in E8 is 0% instead of 200%

Is there another way of getting around the DIV/0 error other than the method that I am using? B8=0,-"0%


But if cell B8 contains the value of zero, I do not get the DIV/0 error, but the value in E8 becomes zero which is incorrect

 

[Special-K99]

If B8 is 0 then (C8-B8)/B8 will give you a DIV/0 error so check for B8 being 0 FIRST, hence

=IF(B8=0,-"0%",(C8-B8)/B8)

But you say if B8=0 you want the result to be 200% so just change the formula to

=IF(B8=0,"200%",(C8-B8)/B8)

 

[123rickfear]

=IF(B8=0,C8,(C8-B8)/B8)

does this do what you want?

 

[meppwc]

yes, thats it........now that I see it it is so obvious.....thanks a lot