Excel...

[RFMontraz]

Hi all



I looked around but cannot find an answer for this very basic issue: is there a IFERROR sort of formula which includes ALL sort of errors (say all non numerical values)?



For example #N/A Sec is not read as error by the plain vanilla IFERROR formula...



Thank you all

[tristanreid]

No, ISERROR is the widest one, afaik.



There are others, e.g.:  ISERR + NA = ISERROR



The problem is that 3rd-party addins like BBG can just put in a string, which is different than an error code.



Probably the solution is to try to convert to whatever type you need and then read an error message if the conversion fails.  Or ISNUMBER type of stuff.



-t.

[Hansi]

Should also be easy to rolla UDF that checks for value2 elements as strings, e.g. cell.value2.match("#N/A") etc

[Cheng]

Bbg returns all kind of stuff which is not an error code but looks like one. If you want to play it safe use something like



OR(ISERROR(cell),LEFT(cell,1)="#")



or indeeed ISNUMBER if you expect numerical values.

[RFMontraz]

Thanks guys. In the end I tweaked it using a couple of IFs