software

Actually I have 1 more question ;-). Let's say that in cell A1 I can have
values quot;yesquot;, quot;noquot; and quot;#N/Aquot;. 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=quot;#N/Aquot;;0;1) or
if(A1=NA();0;1) works.

lucas

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

--
Kind regards,

Niek Otten

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

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

Does that help?

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

XL2002, WinXP-Proquot;lucasquot; wrote:

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

Great! This one helps as well. Thanks Ron!

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; =IF(ISNA(A1),0,1)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;lucasquot; wrote:
gt;
gt; gt; Actually I have 1 more question ;-). Let's say that in cell A1 I can have
gt; gt; values quot;yesquot;, quot;noquot; and quot;#N/Aquot;. I wanna set up a formula which will say that
gt; gt; if A1 is different from #N/A then show 1, if not then 0. But there is sth
gt; gt; strange about this #N/A neither of my formulas if(A1=quot;#N/Aquot;;0;1) or
gt; gt; if(A1=NA();0;1) works.
gt; gt;
gt; gt; lucas