For instance, for the first part:
=IF(ISNUMBER(FIND("happy",A1)),"so happy","")
Because the IF function doesn't support the use of wildcards.Thanks.
but,why doesnt it work?
Because the IF function doesn't support the use of wildcards.
Functions that support the use of wildcards:
SUMIF - all versions of Excel
COUNTIF - all versions of Excel
SEARCH - all versions of Excel
MATCH - all versions of Excel
HLOOKUP - all versions of Excel
VLOOKUP - all versions of Excel
SUMIFS - Excel 2007 and later
COUNTIFS - Excel 2007 and later
AVERAGEIF - Excel 2007 and later
AVERAGEIFS - Excel 2007 and later
Can't tell from those pictures what you're trying to do.anyone can help me?