Actually I have 1 more question ;-). Let's say that in cell A1 I can have
values "yes", "no" and "#N/A". I wanna set up a formula which will say that
if A1 is different from #N/A then show 1, if not then 0. But there is sth
strange about this #N/A neither of my formulas if(A1="#N/A";0;1) or
if(A1=NA();0;1) works.

lucas

=IF(ISNA(A1);0;1)

--
Kind regards,

Niek Otten

"lucas" wrote in message
...
Actually I have 1 more question ;-). Let's say that in cell A1 I can have
values "yes", "no" and "#N/A". I wanna set up a formula which will say
that
if A1 is different from #N/A then show 1, if not then 0. But there is sth
strange about this #N/A neither of my formulas if(A1="#N/A";0;1) or
if(A1=NA();0;1) works.

lucas

Try something like this:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"lucas" wrote:

Actually I have 1 more question ;-). Let's say that in cell A1 I can have
values "yes", "no" and "#N/A". I wanna set up a formula which will say that
if A1 is different from #N/A then show 1, if not then 0. But there is sth
strange about this #N/A neither of my formulas if(A1="#N/A";0;1) or
if(A1=NA();0;1) works.

lucas

Great! This one helps as well. Thanks Ron!

"Ron Coderre" wrote:

Try something like this:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"lucas" wrote:

Actually I have 1 more question ;-). Let's say that in cell A1 I can have
values "yes", "no" and "#N/A". I wanna set up a formula which will say that
if A1 is different from #N/A then show 1, if not then 0. But there is sth
strange about this #N/A neither of my formulas if(A1="#N/A";0;1) or
if(A1=NA();0;1) works.

lucas