SEARCH returns an error, not TRUE or FALSE, if the searched for text is not
found.

Rick


"Soulscream" wrote in message
...
Hey, it worked! Thanks. Can you tell me why it won't work without the
ISNUMBER function out of curiosity?

"PCLIVE" wrote:

Try this:

=IF(ISNUMBER(SEARCH("SUNDAY",D28)),"",IF(ISNUMBER( SEARCH("SUNDAY",D25)),Z23+1,""))

HTH,
Paul


--

"Soulscream" wrote in message
...
Hi,
I'm trying to write a complicated equation and I need it to search 2
different cells for the word "Sunday". I'm trying to put both in an IF
equation, but they won't both work properly. Here's my example:

=IF(SEARCH("SUNDAY",D28),"",IF(SEARCH("SUNDAY",D25 ),Z23+1,""))

In the above equation, the first function works and leaves the cell
blank,
but if the search for "Sunday" is FALSE it returns a #Value! error.

...any ideas?