IF Statement Logical Test Prob finding "#n/a"

[vargs]

Hello,

I am having some slight difficulty getting this simple if statement to work and I am pretty sure it has to do with the logical test in the formula.

In the example I have attached, I write =IF(E2="#N/A",C2,0)
which I intend to mean:
if cell E2 = "#N/A", give me the contents of C2, if not, output the value 0

This does work however if i change the referenced column and the code to equal just "N/A"

I was just wondering if there was a way of doing this in one step.

Thanks,

-vargs

[ChemistB]

#N/A is actually an error message and is not seen as text. There's a function ISNA(Cell) specific for this so

=IF(ISNA(E2),C2,0)
Does that work for you?

[TMS]

Try:

=IF(ISNA(E2),C2,0)


Regards

[davegugg]

Try using the IsError function instead:

Please Login or Register  to view this content.

[vargs]

Both of those statements worked great.

That is neat how you,TM Shucks and davegugg, each had a different approach that are equally as good.

Thanks so much for your help.

Sincerely,

-vargs

[TMS]

You're welcome. It's quite fascinating how many ways you can find to solve a problem ;-)

Thanks for the rep.

Regards