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