You can't use wildcards in logical functions (you can use it in lookups,
match, sumif etc), but you can get the equivalent using search/find (find if
you want it to be case sensitive like Jones and not jones)

=IF(AND(Data!C8="Town",OR(ISNUMBER(SEARCH({"Smith" ,"Jones"},Data!C5)))),0.03,0.05)

should do it if you want 0.03 if the conditions are TRUE and 0.05 if FALSE

Regards,

Peo Sjoblom

"Slagmendoza" wrote:

Hi,

I have the following formula:

=IF(AND(Data!C8="Town",Data!C5="Smith"),0.03,IF(AN D(Data!C8="Town",Data!C5="Jones"),0.03,0.05))

I want to change a value in a cell (to either 0.03 or 0.05) depending on
what values are in two other cells on worksheet Data. If DataC8 = "Town" AND
DataC5 = ANYTHING that contains either "Smith" OR "Jones" (could be Smith,
Smith Brothers, Smith Boys, etc, OR Jones, Jones Brothers, Jones Boys, etc.).

Is it possible to use wildcards in the above formula somehow to accomplish
this?

Thanks!