test for #NA , help please

  • Thread starter Thread starter dido22
  • Start date Start date
D

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
 
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.
Click to expand...

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)
 
This works nicely thanks

KK


Stan Brown said:
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)
Click to expand...
 
Back
Top