a test for #N/A

I had no luck searching the forums for #N/A related so I may be asking a question already answered.

I need to test cells for the presence of a #N/A error code. I would prefer to use an IF() statement. Is this possible?

Thanks in advance!

Hi,

You can test it with the function Isna()

HTH
Carim

Hi elrussell,

Try this

=IF(ISNA("A1"),0,"A1")

if range A1 is #N/A then its else leave the value

You could do this in another cell range

You usuall get #N/A using VLookup. so try this

=If(ISNA(VLOOKUP("A1",B1:C1,1,FALSE),0,VLOOKUP("A1",B1:C1,1,FALSE))

The only problem with that is that it does a vlookup twice. So do the vlookup in e.g. col A and the ISNA in col B

Hope this helps
mccreaso

works like a charm - thanks!