Get rid of the percent symbol or help with (#DIV/0!)

[kkmatheso]

Help....I have a column that is the sum of 2 other columns. I need it to list as a percentage, but without the percentage symbol. I used the formula of dividing one cell against the other than times it by 100. [ie. (A1/A2)*100], which works. However when the value is 0 (ie. 10/10) then I get a zero error (#DIV/0!) instead of 100%.

Does anyone know any other way to make a cell compute as a percentage without having the percent symbol....OR.... a way that I can get around the zero error (#DIV/0!) in cases where it is 100%.

 

[dhExcel]

10/10 equals 1.

 

[John Davis]

Help....I have a column that is the sum of 2 other columns. I need it to list as a percentage, but without the percentage symbol. I used the formula of dividing one cell against the other than times it by 100. [ie. (A1/A2)*100], which works. However when the value is 0 (ie. 10/10) then I get a zero error (#DIV/0!) instead of 100%.

Does anyone know any other way to make a cell compute as a percentage without having the percent symbol....OR.... a way that I can get around the zero error (#DIV/0!) in cases where it is 100%.

Maybe:

=IF(A2>0,(A1/A2)*100,"")

 

[kkmatheso]

10/10 equals 1.

I know that, which is why I was asking for help when the formula (10/10)*100 is bringing back a zero error(#DIV/0!).

 

[tbablue]

Not sure how your sheet is set-up but couldn't you just wrap the whole thing in IFERROR ?

=IFERROR((A1/A2)*100,"") - to hide

or

=IFERROR((A1/A2)*100,1) - for 100%

HTH

 

[tbablue]

assumes of course 2007

else in 2003

=IF(ISERROR((A1/A2)*100,"",(A1/A2)*100) - to hide

or

=IF(ISERROR((A1/A2)*100,1,(A1/A2)*100) - for 100%