Basic Functions: ISERR
It is useful to be able to control the appearance of error values in your spreadsheet. The example shows how to do this for string searches.
In the sample spreadsheet below - we see two ways to use the SEARCH function in a spreadsheet. If SEARCH does not produce a match, the we get #VALUE! in the cell - perhaps not acceptable from an aesthetic point of view. However, by usinf the ISERR function, we can filter out the #VALUE! entries - as illustrated.
October 5th, 2007 at 4:51 am
Very useful! I was getting crazy with #VALUE!.
Thank you very much!