I am using this formula

```
=IF((LEFT($B26,2)="<p"),0,IF($B26="",0,IF($F26<>"",0,(FIND("""../",$B26)))))
```

To parse data similar to the following.

```
<nobr> contractor information</nobr><br>
<a href="../City_Electrical_Inspectors.htm"><b> City Electrical Inspectors</b></a><br>
<nobr> <a href="../City_Electrical_Inspectors.htm"><b>inspection</b></a></nobr><br>
```

My problem comes in cases such as the first line, in which the line is not a new paragraph nor a link, and my `FIND`

returns an error of `#VALUE!`

Id like to create an `IF`

test to scan the line for the existence of the pattern in my `FIND`

statement before processing that statement. I figured that looking for an error condition may be the way to go. However, the only way I can envision this is as a self-referential formula, similart to the following pseudocode.

IF(ISERROR($L26)=TRUE,$L26=0,L$26=the-result-of-the-formula-above)

Can this be done with a formula or do I need to use a new helper column?

Thanks.