software

What is the syntax for an if/then/else that recognizes the #N/A? If a cell
returns the #N/A error I want to do one thing. If it returns a number I want
to do something else.

I tried to do less than a huge number, knowing that any number will be less
than the huge number but that doesn't work.

Hi

Try something like this:
=IF(ISNA(A2),quot;Yquot;,quot;Nquot;)

Andy.

quot;Box815quot; gt; wrote in message
news
gt; What is the syntax for an if/then/else that recognizes the #N/A? If a
gt; cell
gt; returns the #N/A error I want to do one thing. If it returns a number I
gt; want
gt; to do something else.
gt;
gt; I tried to do less than a huge number, knowing that any number will be
gt; less
gt; than the huge number but that doesn't work.
Thanks! That works great.

quot;Andyquot; wrote:

gt; Hi
gt;
gt; Try something like this:
gt; =IF(ISNA(A2),quot;Yquot;,quot;Nquot;)
gt;
gt; Andy.
gt;
gt; quot;Box815quot; gt; wrote in message
gt; news
gt; gt; What is the syntax for an if/then/else that recognizes the #N/A? If a
gt; gt; cell
gt; gt; returns the #N/A error I want to do one thing. If it returns a number I
gt; gt; want
gt; gt; to do something else.
gt; gt;
gt; gt; I tried to do less than a huge number, knowing that any number will be
gt; gt; less
gt; gt; than the huge number but that doesn't work.
gt;
gt;
gt;