How to determine if a cell contains a comma

[alderman]

I would like an equation that can identify if there is a comma in a cell

For example,

"red" would return "no", but "red, yellow" would return "yes"

[alderman]

Sorry, false alarm... figured it out using countifs, unless someon has a better solution.

[Simi]

you could use something like

=IF(IFERROR(SEARCH(",",A1,1)>1,0),"yes","no")

instead of using search you could also use find. these are similar to using instr() in VBA.

[martindwilson]

=IF(ISNUMBER(FIND(",",A1)),"yes","no")