Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.