Changing #DIV/0 to a value of 0

[trfarley05]

I have 18 cells (F6 to W6) with either the value of Y, N or N/A. I have created a countif formula in cell X6 that should give a percentage of Y's divided by Y+N's. I have all N/As in this instance so basically I am diving 0 by 0. I get the value to #DIV/0. How do I change this to the value of zero???

[dilipandey]

Hi trfarley05,

See the attached file and let me know if this works. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[jlhudson]

Use the Formula
if A1 is the Cell containing the #Div/0

=if(isError(A1),0,A1)

Hope this helps.

[Cutter]

Since you have version 2007 you can use:

=IFERROR(your current formula,0)