Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Am using a bloomberg Add-in, and I get an error that shows #N/A N/A and I've also got some #NUM! errors.

IFERROR doesn't work because #N/A N/A isn't a standard excel error.

Is there any excel formula I can use to ignore errors, maybe using if or something?

share|improve this question
Sorry, but your question isn't very clear. Can you give us an example? IFERROR understands all error codes (#N/A and #NUM! included) – Rhys Gibson Sep 28 '12 at 3:53
yes but #N/A N/A is an error code that is not a standard excel error. – POGO Sep 28 '12 at 4:12
If it's not an error, what do you expect the output to be? Is it a number, text, or something else? There may be a function to check for that rather than checking for errors. – Hand-E-Food Sep 28 '12 at 4:28

Looks like you are using Excel 2010 so try

=IFERROR(IF(A1="#N/A N/A","No","Yes),"No")

or in any version

=IF(ISERROR(A1),"No",IF(A1="#N/A N/A","No","Yes))

Replace the "No" values (there are two) with what you want to happen for "errors" and "Yes" with what you want to happen for other entries.

....or shorter but more opaque....

=IF(COUNT(1/(A1<>"#N/A N/A")),"Yes","No")

share|improve this answer
If your output is just number, you can shorten it to =iferror(--A1,"No") – nutsch Sep 28 '12 at 16:53
Hey Thomas! Nice one – barry houdini Sep 28 '12 at 17:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .