F
forumuser - ExcelForums.com
Hello
Here's the deal -- I'm trying to get a percentage value for column V
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/
error of I try to calculate a percentage (using =V/B)
As a workaround, I have tried "=IF(ISERROR(B4/C4=0),"",D4/C4)" wher
B4 is the cell in column A, C4 is the cell in column B and th
percentage of variance (VP) is the cell in column V divided by th
cell in column B
The problem is that the ISERROR formula as I have written it will no
show a value for the variance where there is 0 in either column A o
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 ge
written while still suppressing the error message
Thanks for any help with this
Here's the deal -- I'm trying to get a percentage value for column V
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/
error of I try to calculate a percentage (using =V/B)
As a workaround, I have tried "=IF(ISERROR(B4/C4=0),"",D4/C4)" wher
B4 is the cell in column A, C4 is the cell in column B and th
percentage of variance (VP) is the cell in column V divided by th
cell in column B
The problem is that the ISERROR formula as I have written it will no
show a value for the variance where there is 0 in either column A o
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 ge
written while still suppressing the error message
Thanks for any help with this