View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Box815
 
Posts: n/a
Default If formula that recognizes #N/A

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.