question

[curtisw]

anyone knows?

thanks.

 

[wigi]

For instance, for the first part:

=IF(ISNUMBER(FIND("happy",A1)),"so happy","")

 

[curtisw]

For instance, for the first part:

=IF(ISNUMBER(FIND("happy",A1)),"so happy","")

Thanks.

but,why doesnt it work?

 

[T. Valko]

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

 

[curtisw]

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

got it, thanks

 

[T. Valko]

got it, thanks

You're welcome!

 

[curtisw]

sorry,still have problem..

it works in excel 2010,but it doesnt work in excel 2002...
it shows true or false...

I have used the find function, but it doesnt work...

how to formulate it in excel 2002?
my company is still using such old version....


thanks

 

[curtisw]

anyone can help me?

 

[T. Valko]

anyone can help me?

Can't tell from those pictures what you're trying to do.

Just post the sample data directly into the the reply.

There is an add-in here that is very helpful in allowing you to demonstrate sample data:

http://www.excel-jeanie-html.de/index.php?f=1

 

[curtisw]

how to formulate it in excel 2002?

thanks