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!