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

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



On May 13, 6:22*pm, mahmoud moustafa <mahmoud
wrote:
Hi
How do i remove the #n/a and make it 0

Hi,

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

"mahmoud moustafa" wrote:

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

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))


"mahmoud moustafa" wrote:

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

On May 13, 7:22*am, mahmoud moustafa <mahmoud
wrote:
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:D$7,2,0), "")