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,

Looks like you want to insert the OR function for the first parameter of the IF statement, for its arguments you'll replicate that find function once per each string you are searching for:
IF(
OR(Find#1, find#2, find#3),
do x,
do y
)

Thanks Warren,

I tried:

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

I cannot get it to verify. What would be the error?

Thanks,

Remove the comma after the last FIND statement:

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

I hate to be a pain, but I have copied that exact formula into Gridview and I still fail the verification.

IF(
OR(
FIND("YX",{Item #},1) > 0,
FIND("ZB",{Item #},1) > 0,
FIND("TV",{Item #},1) > 0
)
{Amt} * 2%,
{Amt} * 3.25%
)

Lance,
I think the issue is that all of the if statements posted after my initial reply are lacking the comma to separate out the OR function as the #1 parameter of the IF statement. You had the correct number of commas the first time, just not in the right place:
If (
Or (find(xxxx)) ,
do x,
do y
)

I haven't used the find function in a little bit but Bruce's suggestion of ensuring the find functions are returning a value >0 is worth considering. The if statement might recognize the returned 0 as false and go to the final part without that, but I'm not sure.

Yes, Warren is correct (he has younger eyes). The comma was missing.

IF(
OR(
FIND("YX",{Item #},1) > 0,
FIND("ZB",{Item #},1) > 0,
FIND("TV",{Item #},1) > 0
),
{Amt} * 2%,
{Amt} * 3.25%
)

Thanks guys! It's working perfect now. 8-)