remove the #n/a and make it 0

[mahmoud moustafa]

Hi
How do i remove the #n/a and make it 0

 

[muddan madhu]

you can use =if(ISNA(your_formula),0,your_formula)

 

[Eduardo]

Hi,

=if(iserror(yourformula),"",your formula)

 

[JLatham]

You need to "wrap" your formula with a test for the error like this:

=IF(ISNA(your formula),0,your formula)

The most common #N/A comes from VLOOKUP() results without a match, so you
might have a formula like this:
=VLOOKUP(A1,B1:J99,3,FALSE)
and you would rewrite it as
=IF(ISNA(VLOOKUP(A1,B1:J99,3,FALSE)), 0, VLOOKUP(A1,B1:J99,3,FALSE))

 

[Armando]

Hi
How do i remove the #n/a and make it 0

Try this one:
=IF(COUNTIF(B$2:B$7,B23),VLOOKUP(B23,B$2$7,2,0),"")