What is the proper way to use multiple IF/OR/AND statements. In this particular case I want to:

Find {Item #} containing "YX" or "ZB" or "TV" and {Amt} * 2%
Everything thing else I want {Amt} * 3.25%

I can get one function working:

IF(
FIND("YX",{Item #},1),
{Amt} * 2%,
{Amt} * 3.25%
)

But I am unsure on how to add the other two.

Thanks,
_________________________
Lance Tennier
TDL Canada