ISERROR Conundrum
 

Hello!

Here's the deal -- I'm trying to get a percentage value for column VP
as presented below:

July 2005
A B V VP

10 4,757 (4,747) -99.79%
0 32,730 (32,730) -100.00%
0 9,519 (9,519) -100.00%
0 4,757 (4,757) -100.00%
10 0 10
0 0 0
20 51,763 (51,743) -99.96%

Since columns A and B may often contain 0 as a value, I get a #DIV/0
error of I try to calculate a percentage (using =V/B).

As a workaround, I have tried "=IF(ISERROR(B4/C4=0),"",D4/C4)" where
B4 is the cell in column A, C4 is the cell in column B and the
percentage of variance (VP) is the cell in column V divided by the
cell in column B.

The problem is that the ISERROR formula as I have written it will not
show a value for the variance where there is 0 in either column A or
B, even though one of the two columns may have a value other than 0.

Does anyone know how to get the variance percentage (VP) to get
written while still suppressing the error message?

Thanks for any help with this.

Just use =if(iserror(b4/c4),"",b4/c4)

if c4=0 then b4/c4 is undefined.
--
Jim


"forumuser - ExcelForums.com" wrote:

Hello!

Here's the deal -- I'm trying to get a percentage value for column VP
as presented below:

July 2005
A B V VP

10 4,757 (4,747) -99.79%
0 32,730 (32,730) -100.00%
0 9,519 (9,519) -100.00%
0 4,757 (4,757) -100.00%
10 0 10
0 0 0
20 51,763 (51,743) -99.96%

Since columns A and B may often contain 0 as a value, I get a #DIV/0
error of I try to calculate a percentage (using =V/B).

As a workaround, I have tried "=IF(ISERROR(B4/C4=0),"",D4/C4)" where
B4 is the cell in column A, C4 is the cell in column B and the
percentage of variance (VP) is the cell in column V divided by the
cell in column B.

The problem is that the ISERROR formula as I have written it will not
show a value for the variance where there is 0 in either column A or
B, even though one of the two columns may have a value other than 0.

Does anyone know how to get the variance percentage (VP) to get
written while still suppressing the error message?

Thanks for any help with this.