Where in Calc can I apply a "contain" or "doe

[kartheek.n]

Where in Calc can I apply a "contain" or "does not contain" condition?
_________________
Kartheek Reddy N

[keme]

You need to apply a search function. If searches do not find a match, they'll return an error, so what you need is to test if the search returns an error. Substitute values or references for the items in italics below.

For testing a text string for a substring:
=IF(ISERROR(FIND(substring ; searchstring));"Does not contain...";"Contains...")

For testing a cell range for a value:
=IF(ISERROR(VLOOKUP(value ; range ; 1 ; 0));"Does not contain...";"Contains...")

Note that the VLOOKUP() function requires the given range to have at least two columns. For searching a horizontal vector, use HLOOKUP() instead of VLOOKUP().

[kartheek.n]

Thanks for ur Reply Keme
_________________
Kartheek Reddy N