#DIV/0! and IF statement
 

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),"",(a-b/b)) but I get blanks even if the
answer is -100%.

Thanks!

#DIV/0! and IF statement
 

James,

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

"James Hamilton" wrote:

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),"",(a-b/b)) but I get blanks even if the
answer is -100%.

Thanks!

#DIV/0! and IF statement
 

Go to tools and click conditional formatting. Click on the drop down
list and select "Formula is" 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)

#DIV/0! and IF statement
 

Excellent. Many thanks.

I actually worked it out the same as below.

Cheers.

"Justloseit" wrote:

Go to tools and click conditional formatting. Click on the drop down
list and select "Formula is" 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)