software

I have 3 columns of data; A, B and C.

The formula for column C is = (A-B)/B

If column A is 0, then the result is -100%

If both column A and column B is 0 the result is #DIV/0!

What formula do I use so that when the answer is -100%, it says this, but
when the answer is #DIV/0!, I get a blank?

I'm trying is =if(iserror((a-b)/b),quot;quot;,(a-b/b)) but I get blanks even if the
answer is -100%.

Thanks!James,

=IF(B1=0,quot; quot;,(A1-B1)/B1)

quot;James Hamiltonquot; wrote:

gt; I have 3 columns of data; A, B and C.
gt;
gt; The formula for column C is = (A-B)/B
gt;
gt; If column A is 0, then the result is -100%
gt;
gt; If both column A and column B is 0 the result is #DIV/0!
gt;
gt; What formula do I use so that when the answer is -100%, it says this, but
gt; when the answer is #DIV/0!, I get a blank?
gt;
gt; I'm trying is =if(iserror((a-b)/b),quot;quot;,(a-b/b)) but I get blanks even if the
gt; answer is -100%.
gt;
gt; Thanks!
gt;

Go to tools and click conditional formatting. Click on the drop down
list and select quot;Formula isquot; then type this in the text box next to it
=ISERROR(C3)

Then click format button and click the color drop down box and select
white. (Even if the orginal color of the color drop down box is white
still click on it and select white or it will not work)Excellent. Many thanks.

I actually worked it out the same as below.

Cheers.

quot;Justloseitquot; wrote:

gt; Go to tools and click conditional formatting. Click on the drop down
gt; list and select quot;Formula isquot; then type this in the text box next to it
gt; =ISERROR(C3)
gt;
gt; Then click format button and click the color drop down box and select
gt; white. (Even if the orginal color of the color drop down box is white
gt; still click on it and select white or it will not work)
gt;
gt;