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