test for #NA , help please

[dido22]

Hello

I have a column of numbers (eg in column A), some of which are set to #NA by
entering NA() as part of an IF function.. I need to do this to avoid the
cell being plotted on chart . No problem.

In another column I need to test the cell. If it has a number in it I want
to return the number 100, if it is #NA I need to set it to 25.

How do I test a cell for the value #NA ??

I have tried =IF(A1=NA(), 25,100), but just get #NA again.

Help please ?

K

 

[Stan Brown]

I have a column of numbers (eg in column A), some of which are set to #NA by
entering NA() as part of an IF function.. I need to do this to avoid the
cell being plotted on chart . No problem.

In another column I need to test the cell. If it has a number in it I want
to return the number 100, if it is #NA I need to set it to 25.

How do I test a cell for the value #NA ??

I have tried =IF(A1=NA(), 25,100), but just get #NA again.

You didn't tell us which version of Excel you have, but if it's a
fairly recent one the function you want is =ISNA( ). Type
=isna(
in a blank cell and then press Ctrl-A rather than the Enter key to
see if your version has that function.

=IF (ISNA(A1), 25, 100)

 

[dido22]

This works nicely thanks

KK

You didn't tell us which version of Excel you have, but if it's a
fairly recent one the function you want is =ISNA( ). Type
=isna(
in a blank cell and then press Ctrl-A rather than the Enter key to
see if your version has that function.

=IF (ISNA(A1), 25, 100)