I am trying to write a find function, and the [value\_if\_true] is given "Yes" and [value\_if\_false] is given "No". Here's the simple code:

```
=IF(FIND("T",B2),"Yes","No",)

```

Cell B2 contians "Apples" If I put "A" into the first part of the "FIND" function, the function returns "YES", as it should. But when I put "T" or anything that is not in the word "Apples", it returns #VALUE. I do not know why. Any ideas?

Thanks!