Using wildcard with or

[skurkal]

I have a data set that looks like

Payee Amount
Target 010 10
Target 011 20
Target 001 30
Home Depot 01 10
Home Depot 02 20
Home Depot 001 30

It want to group this into a HomeImprovement category. How to I write a formula that allows :

If Payee like ('Target*' or 'Home Depot *) then 'HomeImprovement"
Else 'Other'

I am using CR XI, and it does not allow using like and or together.
Thanks!

 

[fisheromacse]

you can separate it out, like this:

If payee like 'Target*' then "HomeImprovement"
ELSE
If payee like 'Home Depot *' then "HomeImprovement"
else "Other"

 

[AndyMc]

Try:

If Payee like ['Target','Home Depot'] then 'HomeImprovement"
Else 'Other'

 

[skurkal]

This worked ...

If Payee like ['Target*','Home Depot*'] then 'HomeImprovement"
Else 'Other'


Thanks!