Convert #N/A to a 0 (zero)

Guest · Oct 21, 2004

I have a formula which results in a #N/A. How can I convert this to 0 (zero)?

Niek Otten · Oct 21, 2004

=IF(ISNA(YourFormula),0,YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Find/Replace Select Numbers in a Cell	3	Nov 4, 2010
N/A in pivot table become 0	1	Jan 12, 2012
How to set a formula if the value is with #N/A	4	Mar 15, 2010
Using INDEX and it Returns a #N/A	2	Jan 8, 2008
#n/a - in vlookup	1	Jul 19, 2003
VLookup - Need Zero (0) Value Not #N/A When False	2	Feb 28, 2004
How can I automatically replace the error #N/A with 0 in Excel?	3	May 28, 2008
First row where a cell is zero	1	Aug 5, 2012

Ask a Question