« Database functions: DAVERAGE | Main | Charting: Pie charts »
November 17, 2004
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.
Posted by Dave at November 17, 2004 05:56 AM