Concatenate with Multiple If Statements

[fuzzyslippers]

This seems so simple by I'm stumped.

If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";"

returns exactly what I need it to:

Appliance Cookbooks>Data from Cat Appliance Field;

now, I need to go on so I end up with this:

Appliance Cookbooks>Data from Cat Appliance Field;Ethnic Cookbooks>Data from Ethnic Cookbook Field;

So is there a way to string two If statements together or should I be using something else??

If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";"

If(IsEmpty(Cat Ethnic);""; "Ethnic Cookbooks" & ">" & Cat Enthic & ";"

Thanks! fuzzy

[comment]

If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";"

returns exactly what I need it to:

I don't think so, because the parentheses are not balanced. Anyway, you can concatenate the results of If() statements the same way you concatenate other strings =

If ( not IsEmpty ( Cat Appliance ) ; "Appliance Cookbooks>" & Cat Appliance & ";" )

&

If ( not IsEmpty ( Cat Ethnic ) ; "Ethnic Cookbooks>" & Cat Ethnic & ";" )

[fuzzyslippers]

Perfect, woo hoo, thanks so much.