G
Guest
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!
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!