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),"Y","N")

Andy.

"Box815" wrote in message
...
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.

Thanks! That works great.

"Andy" wrote:

Hi

Try something like this:
=IF(ISNA(A2),"Y","N")

Andy.

"Box815" wrote in message
...
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.