Hi!

If there is no comma the SEARCH function returns the #VALUE! error which is
in turn passed to IF.

Try this:

=IF(ISNUMBER(FIND(",",F121)),"y","n")

Biff

"Shakespeare"
wrote in message
...

Here's the formula:

=IF(SEARCH(",",F121)0,"y","n")

I'm looking for commas, the above formula returns a "y" when it finds a
comma, however it doesn't return the "n" when it doesn't... I get a
#value! error.

What have I done wrong?


--
Shakespeare
------------------------------------------------------------------------
Shakespeare's Profile:
http://www.excelforum.com/member.php...o&userid=21552
View this thread: http://www.excelforum.com/showthread...hreadid=530809